LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 204
Default DSUM with dates

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
dsum Srinivas Excel Discussion (Misc queries) 2 December 30th 08 01:16 PM
DSUM with dates?? [email protected] Excel Worksheet Functions 1 July 26th 06 09:06 AM
Using DSUM JoeRapacilo Excel Worksheet Functions 1 March 10th 06 07:02 PM
Sum If or DSUM help? towl Excel Worksheet Functions 2 August 16th 05 03:30 PM
DSUM Tnknsnj Excel Worksheet Functions 1 June 10th 05 03:31 AM


All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"