N
Nancy
Does anyone know how to use DSUM when a desired criteria
value is NULL?
value is NULL?
P
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(A4
10,"header_of_blanks",F1:F2)
=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(A4
10,"header_of_blanks",F1:F2)
N
Nancy
Sorry, that doesn't seem to work for me. Is there more
information on this? Or any other ideas?
information on this? Or any other ideas?
P
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..
character equals null) or you did not apply it correctly.
I know it works..
N
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?
applied it incorrectly.
Questions --
I'm using Excel 97 - how about you?
There's criteria on other columns ... would that matter?
P
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
I can email you a little sample if I get an email address
N
Nancy
That would be great! (e-mail address removed)
P
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
(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