Adding Cell Range with Text
 

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


--
JohnHill
------------------------------------------------------------------------
JohnHill's Profile: http://www.excelforum.com/member.php...o&userid=25171
View this thread: http://www.excelforum.com/showthread...hreadid=389763

Hi!

Try this:

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

Biff

"JohnHill" wrote in
message ...

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


--
JohnHill
------------------------------------------------------------------------
JohnHill's Profile:
http://www.excelforum.com/member.php...o&userid=25171
View this thread: http://www.excelforum.com/showthread...hreadid=389763

Biff,

Great stuff .... Thanks very much.

John


--
JohnHill
------------------------------------------------------------------------
JohnHill's Profile: http://www.excelforum.com/member.php...o&userid=25171
View this thread: http://www.excelforum.com/showthread...hreadid=389763