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

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

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