DSUM

[J Le Brasseur]

Sorry I cant get updates on worksheet functions so I am posting this
question again here.
Is it possible to get DSUM to recognize a blank cell in the criteria as a
means of selecting and filtering data from the database?
JLB

 

[Debra Dalgleish]

As answered in worksheet.functions:

In the criteria area, leave the heading cell blank.
In the cell below, enter a formula that refers to the first cell with
data in the column which contains the blank cells. For example, if you
want to total rows where the customer name is blank, and customer name
is in column F, the criteria area (L1:L2) would contain the following:

L1:
L2: =F2=""

The DSUM formula would refer to both cells in the criteria area, e.g.:

=DSUM(Database,7,L1:L2)