SUMIF with blank cells criteria -- can it be done? - Page 2
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: SUMIF with blank cells criteria -- can it be done?

  1. #11
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,786
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: SUMIF with blank cells criteria -- can it be done?

     
    Quote Originally Posted by TT2013 View Post
    The value of the 0 cells =value(J23) is 0, even though it is blank in the cell.
    Does...

    =SUMIF(J23:J32,"=",H23:H32)

    do what you want?
    Assuming too much and qualifying too much are two faces of the same problem.

  2. #12
    New Member
    Join Date
    Apr 2013
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: SUMIF with blank cells criteria -- can it be done?

    Yes, it does, it does..

    I thought criteria is supposed to a logical expression. How come "=" work when "=0" doesn't for checking whether the cell is 0?

    Thanks again, Aladin

  3. #13
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,786
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: SUMIF with blank cells criteria -- can it be done?

      
    Quote Originally Posted by TT2013 View Post
    Yes, it does, it does..
    Great.

    I thought criteria is supposed to a logical expression. How come "=" work when "=0" doesn't for checking whether the cell is 0?
    SumIf does not coerce empty cells into 0's, so a =0 is unusable. Just a "=" test picks out the empty cells (but not non-blanks), and "<>" the non-empty cells.

    Thanks again, Aladin
    You are welcome. Thanks for providing feedback.
    Assuming too much and qualifying too much are two faces of the same problem.

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