Sumif

[jjj]

HI,

This should be quite straight forward,

How can i use sumif ( all values are numeric), and return "Fail" if any of them contain a text?

[Domenic]

Try the following...

=IF(SUMPRODUCT(--(ISTEXT(A1:A10))),"Fail",SUM(A1:A10))

OR

=IF(SUMPRODUCT(--(ISNUMBER(A1:A10)))=ROWS(A1:A10),SUM(A1:A10),"Fail")

...which will also return "Fail" if any of the cells is empty.

Hope this helps!

HI,

This should be quite straight forward,

How can i use sumif ( all values are numeric), and return "Fail" if any of them contain a text?