sum a range between two given dates.

A

Arristabryan

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
Click to expand...
date entry. however i justy keep getting an error. Any of you genius' out
there got any ideas please
 
B

Bob Phillips

=SUMPRODUCT(--(A2:A200>=--"2006-0101"),--(A2:A200<--"2006-04-01"),B2:B200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top