Sumif cell value is not NA
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Sumif cell value is not NA

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    San Diego
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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


    Regards,

    Gary Hewitt-Long

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    San Diego
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com