Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chantilly, VA USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SumIF If Range Is Blank

    I've got a SUMIF problem

    Range A1-A100 has a row of dollar values. Range B1-B100 has a range of dates. Some of the cells in B1-B100 are blank -- there are no dates in them.

    I want to sum all the cells in A1-A100 IF the corresponding cell in B1-B100 is blank.

    I know that SUMIFS(A1:a100,B:B100,">1" will give me all the cells that DO have a value (are NOT blank).

    How can I sum the ones that ARE blank?

    =(SUM(A1:Aa100)-(SUMIFS(A1:A1A100,B1:B100,">1"))) seems to do it, but that's a little clunky.

    Is there a simpler solution?

    thanks

    Don

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi Don

    What you need is:
    =SUMIF(B1:B100,"",A1:A100)

    ..you don't need the multiple SUMIFS version.

    zeddy

Posting Permissions

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