Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: SUMIF (I Think)...Help on summing a range with different val

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I have a column of values in A, the values include "POA" , "#N/A", "0", Blank Cells and Cells with Data in.

    I want to sum the numeric values in A, ignoring everything else. (I want the total to be displayed at the bottom of COlumn A)

    Any Ideas ?

    Cheers
    Darren

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,021
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-04-09 09:30, traversd wrote:
    Hi,

    I have a column of values in A, the values include "POA" , "#N/A", "0", Blank Cells and Cells with Data in.

    I want to sum the numeric values in A, ignoring everything else. (I want the total to be displayed at the bottom of COlumn A)

    Any Ideas ?

    Cheers
    Darren
    Use:

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

    where A1:A7 is the target range of interest. Adjust to suit.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks,

    I had "POA" in there as well, but it seems to have ignored that which i what i wanted.

    Thanks
    Darren

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,021
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-04-09 09:40, traversd wrote:
    Thanks,

    I had "POA" in there as well, but it seems to have ignored that which i what i wanted.

    Thanks
    Darren
    Aggregating functions like SUM, AVERAGE, and SUMIF simply ignore the text values in the range they are fed with.

    Aladin

Some videos you may like

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
  •