| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum a range between two given dates.
=SUMPRODUCT(--(A2:A200=--"2006-0101"),--(A2:A200<--"2006-04-01"),B2:B200)
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Arristabryan" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum a range between two given dates.
Arristabryan,
Sounds like a good use for a pivot table. hth, Doug "Arristabryan" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible to chart data for dates implicit within a range? | Charts and Charting in Excel | |||
| Identifying Overlapping Dates within a range | Excel Worksheet Functions | |||
| count number of years 2003 in a range of dates | Excel Worksheet Functions | |||
| How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Linear Mode
