Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
PiRaTe_ PiRaTe via OfficeKB.com
 
Posts: n/a
Default BETWEEN DATES SUM

=SUMIF(A1:A9,"<="&DATE(2004,4,2),B1:B9)-SUMIF(A1:A9,"<"&DATE(2004,3,29),B1:B9)

Try something like the above.

A1:A9 would reference your dates to be summed.

B1:B9 references the column to be summed due to the specified date range.

Of course you would need to set your range in the identical format.

Hope this helps you out

--
Message posted via http://www.officekb.com
Reply
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
Ploting dates against a calendar and not as a simple events Barb Reinhardt Charts and Charting in Excel 2 January 22nd 05 03:41 AM
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:43 PM
Entering dates in Excel 2002 DickG Excel Discussion (Misc queries) 3 January 9th 05 03:56 PM
I get wrong dates when i paste from a different sheet into a new s mmollat Excel Discussion (Misc queries) 2 January 6th 05 08:35 PM
Filtering with dates T Excel Discussion (Misc queries) 1 December 29th 04 08:01 PM


All times are GMT +1. The time now is 10:01 PM.

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

About Us

"It's about Microsoft Excel"