summing across cells containing #n/a
Posted by coline on January 24, 2002 12:27 PM
Hi, I have a situation in which I would like to sum across cells that may contain #n/a values in some cases. Is there a way to sum across these cells or to prevent these values from appearing when they are the result of a formula looking at cells with missing data?
Thanks
Posted by Aladin Akyurek on January 24, 2002 12:29 PM
=SUMIF(A1:K1,"<>#N/A")
will do what you want.
Posted by bob Umlas on January 24, 2002 12:32 PM
ctrl/shift/enter:
=SUM(IF(NOT(ISNA(A1:A10)),A1:A10))
Posted by coline on January 24, 2002 12:32 PM
Thanks! I appreciate the immediate response!
