Dsum excluding blanks

  • Thread starter Thread starter Michelle
  • Start date Start date
M

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
 
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
 
Back
Top