MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sum function returns "N/A" value!!


Posted by Jim on November 12, 2001 2:29 AM

Hi

I'm trying to use the sum function on an array.
The problem is, some values in this array are "N/A" (the result of a VLOOKUP). I'm happy to live with these N/A values, but when I try to sum up the array, I get an "N/A" as well!! Excel's Help says that the sum funtion will not sum up error values or text if they've been TYPED in; i guess i have the problem cos the error values were the result of another funtion. Is there any way I can solve this problem?

Thanx!!


Posted by Aladin Akyurek on November 12, 2001 3:18 AM

Use SUMIF instead of SUM, for example:

=SUMIF(A1:A4,"<>#N/A")

Aladin

=============