Dsum excluding blanks

[Michelle]

Hello, I want to be able to include '=blank' or '<>blank' as a criteria for
one of my columns in my criteria range, but it doesn't seem to work.

Does anyone know a syntax for including all blanks (or all non-blanks) in my
criteria range?

Thanks

M

 

[Ashish Mathur]

Hi,

In the criteria cell, use len(first_cell)=0 to include all blank cells. ust
ensure that the column heading in the criteria range for this column is not
equal one of the headings int eh source data

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com