DSUM with empty cell

[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]

 

[Peo Sjoblom]

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