DSUM with empty cell

  • Thread starter Thread starter Joseph N.
  • Start date Start date
J

Joseph N.

I just noticed that a DSUM function I was using is not working
properly because the criteria includes an empty cell and the function
is not picking up an empty cell as meaning that the criterion is an
empty cell.

Sheet A has:
=DSUM(A:H,"Charge",B!A2:B3)

Sheet B has:
Payable Date Pd
y

In other words, the cell under "Date Pd" is blank, because the
criteria are that there is a 'y' in the payable column and nothing in
the Date Pd column. However, the DSUM function is not picking up the
blank cell. It works if I use 't' and 'f' or other logical terms, but
not 'blank' and 'not blank.'

Is there a way to make the function recognize a blank cell?

[Excel 2003]
 
Remove the header in B2 and in B3 put

=Sheet2!B2=""


where Sheet2!B2 is the first cell with data in the Date Pd column





--


Regards,


Peo Sjoblom
 
Back
Top