Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I need to sum data with reference to a specific date range. For example; I only want to add the dollars that occur between the following date range: 1st of October 2005 - 31st December 2005. My data is presented in columns as follows: Date Dollars dd/mm/yy 20/09/05 $100 01/10/05 $90 01/10/50 $100 03/10/05 $35 15/11/05 $1000 20/12/05 $300 07/01/06 $450 Obviously, the output should be $1525 (90+100+35+1000+300) Im struggling to find the appropriate conditional array formula. I'd appreciate any help. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
date that updates itself daily, plus another formula please?? | Excel Worksheet Functions | |||
Changing a Formula in Conditional Formatting | Excel Worksheet Functions | |||
Conditional formula date | Excel Worksheet Functions | |||
conditional formula to recognize day of the week from date | Excel Discussion (Misc queries) | |||
Formula for date function | Excel Worksheet Functions |