MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!