Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum between dates
Hi, as seen below, I have two columns, one with dates (9-Feb-05), and one with dollar amounts($1.00). Where you see the question mark, I am trying to calculate the total dollars between the "from" and "to" dates using the data in the 2 columns. Does anyone know a formula for this? Thanks FROM TO TOTAL Week 1 3-Mar-05 25-Feb-05 ? Week 2 24-Feb-05 18-Feb-05 ? Week 3 17-Feb-05 11-Feb-05 ? Week 4 10-Feb-05 4-Feb-05 ? Data 9-Feb-05 $1.00 12-Feb-05 $2.00 1-Mar-05 $3.00 20-Feb-05 $5.00 5-Feb-05 $4.00 -- Plasim ------------------------------------------------------------------------ Plasim's Profile: http://www.excelforum.com/member.php...o&userid=28909 View this thread: http://www.excelforum.com/showthread...hreadid=486568 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum between dates
=sumproduct(--($A$1:A$100=to_date_cell),--($A$1:$A$100<=from_date_cell),$B$
1:$B$100) replace the to_date_cell and from_date_cell by the actual cell references. -- HTH RP (remove nothere from the email address if mailing direct) "Plasim" wrote in message ... Hi, as seen below, I have two columns, one with dates (9-Feb-05), and one with dollar amounts($1.00). Where you see the question mark, I am trying to calculate the total dollars between the "from" and "to" dates using the data in the 2 columns. Does anyone know a formula for this? Thanks FROM TO TOTAL Week 1 3-Mar-05 25-Feb-05 ? Week 2 24-Feb-05 18-Feb-05 ? Week 3 17-Feb-05 11-Feb-05 ? Week 4 10-Feb-05 4-Feb-05 ? Data 9-Feb-05 $1.00 12-Feb-05 $2.00 1-Mar-05 $3.00 20-Feb-05 $5.00 5-Feb-05 $4.00 -- Plasim ------------------------------------------------------------------------ Plasim's Profile: http://www.excelforum.com/member.php...o&userid=28909 View this thread: http://www.excelforum.com/showthread...hreadid=486568 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum between dates
Thanks Bob, works great!! Plasim -- Plasim ------------------------------------------------------------------------ Plasim's Profile: http://www.excelforum.com/member.php...o&userid=28909 View this thread: http://www.excelforum.com/showthread...hreadid=486568 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Default Dates | Excel Discussion (Misc queries) | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |