Sum only if all criteria is met

[Mike]

I am trying to put a funtion together to sum a group of
numbers only if all the numbers are above zero. Everything
I've tried has not worked, any sugestions.

Thanks,

Mike

 

[J.E. McGimpsey]

One way:

=SUM(A1:A4)*(COUNTIF(A1:A4,">0")=4)

 

[Geoff]

Try the following:

IF(COUNTIF(A1:X1,0)=0,SUM(A1:X1),"ZEROS APPEAR")

Geoff

 

[J.E. McGimpsey]

Note that this will work correctly if the numbers are zero or above.
However, it will not work if any numbers are *below* zero.