How to create a criteria for blank cells in a SUMIF formula?

  • Thread starter Thread starter Jam'n
  • Start date Start date
J

Jam'n

Formula thus far: =SUMIF(D4:D273,S4:S273,___) where the criteria ___ needs to
find blank cells.
Thanks in advance for your help...
 
Hi,

2nd parameter is the criteria for SUMIF and third parameter is the range to
sum like this:-

SUMIF(CriteriaRange, Criteria, RangeToSum)

Anyway to set the criteria to blank cells just 2 sets double quotes. The
following sums the values in range C1:C16 where the corresponding cell in
range D2:D16 is blank.


=SUMIF(D1:D16,"",C1:C16)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF Function 1
Embed AND formula in SUMIF formula 1
SUMIF with criteria "<>" & "=" 4
SUMIF 2
Blank Suppression 3
Where to put quotes in a SUMIF formula and when is & used for cell 2
Filtering with SUMIFS 1
SUMIF - how to enter a second criteria 1

Back
Top