IF(SUM(COUNTIF stack overflow?

[minorcatherine1]

I think I'm close on this, but can't seem to nail it down.

The file is attached. Please see:

OUTCOMES tab
C39:F47


A47 is working correctly: =IF(SUM(COUNTIF(I27:I44,">=1"))>=3,"YES","NO")

F47 is not working correctly yet: =IF(SUM(COUNTIF(I27:I44,">=1")>=3<>SUM(E44:F44)-SUM(C44:D44)),"YES","NO")
I think it's almost there, but not sure how to adjust it.

I'm trying to get F47 to return "YES","NO" based on ONLY....SUM(G44:H44)-SUM(E44:F44)">=1")>=3
I need it to exclude SUM(E42:F42)-SUM(C42:D42)

Please let me know if I need to clarify further. All help is welcome

[FDibbins]

What are you trying to do with the SUM part? The COUNTIF() will produce a value, so you could probably do away with the SUM - it is only adding 1 number

[FDibbins]

What are you trying to do here?
SUM(G44:H44)-SUM(E44:F44)">=1")>=3

[minorcatherine1]

The SUM is an important part of the code in I39:I44

I'm not sure I understand what you are asking. There are several SUM in there. Which one(s) are you referring to?

[minorcatherine1]

The SUM is an important part of the code in I39:I44

I'm not sure I understand what you are asking. There are several SUM in there. Which one(s) are you referring to?

[minorcatherine1]

I'm trying to do:

=IF(SUM(COUNTIF(I27:I44,">=1"))>=3,"YES","NO")

BUT

exclude the data from SUM(E44:F44)-SUM(C44:D44), which is part of the code in Column I: =IF(C44="","",CHOOSE(COUNT(C44:H44),"",SUM(E44:F44)-SUM(C44:D44),SUM(G44:H44)-SUM(E44:F44)))

[minorcatherine1]

=IF(SUM(COUNTIF(I27:I44,">=1")>=3,"YES","NO"),-SUM(E44:F44)-SUM(C44:D44))

This is close, I think...it's giving me a #value error

[minorcatherine1]

=IF(SUM(COUNTIF(I27:I44,">=1")>=3,"YES","NO"),-(SUM(E44:F44)-SUM(C44:D44)))

#value! error

[minorcatherine1]

Sorry, is my question and what I'm seeking help with unclear?