LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bemused
 
Posts: n/a
Default conditional date formula

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
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
date that updates itself daily, plus another formula please?? Ted Excel Worksheet Functions 2 November 26th 05 03:36 PM
Changing a Formula in Conditional Formatting Dee Excel Worksheet Functions 1 November 2nd 05 04:30 PM
Conditional formula date tghcogo Excel Worksheet Functions 0 October 25th 05 02:52 PM
conditional formula to recognize day of the week from date tiw Excel Discussion (Misc queries) 4 April 20th 05 06:19 PM
Formula for date function Markitos Excel Worksheet Functions 15 November 10th 04 02:05 AM


All times are GMT +1. The time now is 06:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"