DSUM function with NULL

[Nancy]

Does anyone know how to use DSUM when a desired criteria
value is NULL?

 

[Peo Sjoblom]

One way, assume that the criteria range is F1:F2, leave F1 blank and use

=B5=""

in F2

where B5 is the first value in the column where the blanks are (data values
as opposed to headers)

then use

=DSUM(A410,"header_of_blanks",F1:F2)

 

[Nancy]

Sorry, that doesn't seem to work for me. Is there more
information on this? Or any other ideas?

 

[Peo Sjoblom]

If it doesn't work the cells are not blank (some people believe a space
character equals null) or you did not apply it correctly.
I know it works..

 

[Nancy]

The data filters correctly on "blanks" ... so I must have
applied it incorrectly.

Questions --
I'm using Excel 97 - how about you?
There's criteria on other columns ... would that matter?

 

[Peo Sjoblom]

I am using 2002 but there should not be any difference

I can email you a little sample if I get an email address

 

[Nancy]

That would be great! (e-mail address removed)

 

[Peo Sjoblom]

Nancy's problem was that when she selected the ranges from another wb
(although it was open), her
formula got absolute reference since she selected with the mouse in the
other wb, once that was removed everything was hunky dory