Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUM values between dates
I have 2 columns D7:D36 and E7:36
Column D contains dates ie: 9/7/2004 Column E contains a value ie: 2 In another cell I would like to add the values for column E if the corresponding row in D is in the month of September 2004. Any help would be great. |
#2
|
|||
|
|||
Hi
one option =SUMPRODUCT(--(D1:D36=DATEVALUE("9/1/04")),--(D1:D36<=DATEVALUE("9/30/04")),E1:E36) check out http://www.xldynamic.com/source/xld.SUMPRODUCT.html for more details on the sumproduct function Cheers JulieD "Qaspec" wrote in message ... I have 2 columns D7:D36 and E7:36 Column D contains dates ie: 9/7/2004 Column E contains a value ie: 2 In another cell I would like to add the values for column E if the corresponding row in D is in the month of September 2004. Any help would be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ploting dates against a calendar and not as a simple events | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Calculating for number of days when values are in dates | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |