LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arristabryan
 
Posts: n/a
Default sum a range between two given dates.

I have a sheet for my small business. I want to sum all purchases that have
occurred between two dates i.e. each quarter. I have tried using SUMIF then
specifying for range the date entered, then for the criteria I used say
1.1.06 AND <1.4.06 then for the sum range the correspoding values for each

date entry. however i justy keep getting an error. Any of you genius' out
there got any ideas please


 
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
Possible to chart data for dates implicit within a range? Nechama Charts and Charting in Excel 1 September 1st 05 10:11 PM
Identifying Overlapping Dates within a range Tremain Excel Worksheet Functions 1 May 9th 05 10:55 PM
count number of years 2003 in a range of dates Stan Altshuller Excel Worksheet Functions 2 May 3rd 05 07:15 PM
How do I get Excell to sort dates that range from 1800 to 1900's Smith295 New Users to Excel 1 February 22nd 05 06:20 PM
I have a list of dates that I need to count based on a date range ejb030353 Excel Worksheet Functions 4 November 24th 04 02:27 PM


All times are GMT +1. The time now is 10:51 PM.

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"