Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave
 
Posts: n/a
Default How can I sum information in a list with a date range?

How can I sum information in a list with a date range?
My start date is 11/1/04 and my end date is 11/18/04.
I want to sum the "GOOD' column that falls in the date range.

DATE PART W/O # GOOD
11/12/04 2177-2027 2512479 2500
12/01/04 FS9747 2519859 100
10/31/04 2342-00302 2575360 0
12/01/04 2342-00302 2575360 25
11/16/04 2342-00302 2575361 18215


Thanks

  #3   Report Post  
LanceB
 
Posts: n/a
Default

=SUMIF(A2:A6,"="&DATEVALUE("11/1/2004"),D2:D6)-SUMIF(A2:A6,""&DATEVALUE("11/18/2004"),D2:D6)

"Dave" wrote:

How can I sum information in a list with a date range?
My start date is 11/1/04 and my end date is 11/18/04.
I want to sum the "GOOD' column that falls in the date range.

DATE PART W/O # GOOD
11/12/04 2177-2027 2512479 2500
12/01/04 FS9747 2519859 100
10/31/04 2342-00302 2575360 0
12/01/04 2342-00302 2575360 25
11/16/04 2342-00302 2575361 18215


Thanks

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
Help - Information with time and date PM Excel Discussion (Misc queries) 4 January 6th 05 09:25 AM
Counting values within a Date Range Jana Excel Discussion (Misc queries) 7 December 9th 04 11:18 PM
Lookup the latest date in a range so it appears as my result FBB Excel Discussion (Misc queries) 1 December 4th 04 04:50 AM
make list of information from different cells ACTLibrarian Excel Worksheet Functions 1 November 4th 04 10:18 PM
Need to find Min value based on date range entered Chad S Excel Worksheet Functions 1 October 28th 04 09:52 AM


All times are GMT +1. The time now is 09:12 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"