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