Sumif cell value is not NA

[Beginner Bob]

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]

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



good luck

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]

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]

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.