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)
