Adding Cell Range with Text

[JohnHill]

I've got a range of cells to sum. However one or more of the cells may
include "Error". If this occurs I want this to be the sum total so that
the error can be noticed and fixed. Suggestions please !!

Thanks,

John

 

[Biff]

Hi!

Try this:

=IF(COUNTIF(C2:C100,"error"),"error",SUM(C2:C100))

Biff

 

[JohnHill]

Biff,

Great stuff .... Thanks very much.

John