DSUM with dates

M

Michelle

I have a column with some dates and some blanks, and I want to include all
values in my DSUM that have dates in the row - as well as some other
criteria.

I can't find a way to specify in my criteria, that it should include the
date rows and exclude the blanks. I've tried things like '<>""' and '=*' ,
but I can't get it to work.

(It'd even be OK if I could sum all the rows with blanks, because then I
could use the difference from the overall sum)

I'd be very grateful if anyone can point me in the right direction.

Thanks

M
 
T

trip_to_tokyo

=COUNTBLANK(C14:C20)

- will count the blanks for you.

If my comments have helped please hit Yes.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top