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

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

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

=SUMIF(D4:D273,"",S4:S273)

On Dec 10, 12:46*pm, Jam'n wrote:
Formula thus far: =SUMIF(D4:D273,S4:S273,___) where the criteria ___ needs to
find blank cells.
Thanks in advance for your help...

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

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)

--
Regards,

OssieMac


"Jam'n" wrote:

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