Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum value between two dates and copy to new cell
Hi Guys,
Thanks for all the previous helps and guidance on excel sheet and im looking forward for new assistants. i've various dates in column A and values in column B. These values should sum and copy to column E according to date between column C & D, example as below, A B C D E Total 04/01/2010 12 01/01/2010 28/02/2010 02/04/2010 133 01/03/2010 30/04/2010 05/06/2010 154 01/05/2010 30/06/2010 03/04/2010 112 01/07/2010 31/08/2010 05/05/2010 65 01/09/2010 31/10/2010 06/07/2010 34 01/11/2010 31/12/2010 02/01/2010 26 02/03/2010 25 14/02/2010 85 17/08/2010 99 Thanks in advance. dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Pasting Dates | Excel Discussion (Misc queries) | |||
how can I copy dates, etc. without them automatically increasing | Excel Discussion (Misc queries) | |||
Auto copy dates from one cell to another | Excel Discussion (Misc queries) | |||
the dates on cell format make different dates. | New Users to Excel | |||
Copy and paste text and dates | Excel Discussion (Misc queries) |