Thanks:  0
Likes:  0

# Thread: Sumif cell value is not NA

1. 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?

2. 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 ]

3. 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

4. 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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•