Sumif cell value is not NA

Beginner Bob · Feb 28th, 2002, 12:45 PM

I can't believe I can't find an answer to this anywhere, but I have values in cells D8:D59, some of which are NA, which isn't a problem to see, just to sum. I want to sum from D8:D59, ignoring NA values. I've seen and tried way to many methods to list, none of which are working for me. Can someone help me with this formula?

IML · Feb 28th, 2002, 12:47 PM

you could use
=SUMIF(D8:D59,"<>#n/a")

good luck

Quote:

On 2002-02-28 11:45, Beginner Bob wrote:
I can't believe I can't find an answer to this anywhere, but I have values in cells D8:D59, some of which are NA, which isn't a problem to see, just to sum. I want to sum from D8:D59, ignoring NA values. I've seen and tried way to many methods to list, none of which are working for me. Can someone help me with this formula?

[ This Message was edited by: IML on 2002-02-28 11:48 ]

gplhl · Feb 28th, 2002, 12:49 PM

Quote:

On 2002-02-28 11:45, Beginner Bob wrote:
I can't believe I can't find an answer to this anywhere, but I have values in cells D8:D59, some of which are NA, which isn't a problem to see, just to sum. I want to sum from D8:D59, ignoring NA values. I've seen and tried way to many methods to list, none of which are working for me. Can someone help me with this formula?

Use the ISNA function with an IF function to put a default value or zero in the cells that show NA

Beginner Bob · Feb 28th, 2002, 01:23 PM

Thanks gplhl and IML, I ended up using the sumif(D8:D59,"<>#N/A"), because I don't care about seeing the N/A's, and don't want to take the time to change them to 0 amounts.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 12:45 PM	#1
Beginner Bob New Member Join Date: Feb 2002 Location: San Diego Posts: 14	I can't believe I can't find an answer to this anywhere, but I have values in cells D8:D59, some of which are NA, which isn't a problem to see, just to sum. I want to sum from D8:D59, ignoring NA values. I've seen and tried way to many methods to list, none of which are working for me. Can someone help me with this formula?

Feb 28th, 2002, 01:23 PM	#4
Beginner Bob New Member Join Date: Feb 2002 Location: San Diego Posts: 14	Thanks gplhl and IML, I ended up using the sumif(D8:D59,"<>#N/A"), because I don't care about seeing the N/A's, and don't want to take the time to change them to 0 amounts.