software

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
gt;1.1.06 AND lt;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
=SUMPRODUCT(--(A2:A200gt;=--quot;2006-0101quot;),--(A2:A200lt;--quot;2006-04-01quot;),B2:B200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Arristabryanquot; gt; wrote in message
...
gt; I have a sheet for my small business. I want to sum all purchases that
have
gt; occurred between two dates i.e. each quarter. I have tried using SUMIF
then
gt; specifying for range the date entered, then for the criteria I used say
gt; gt;1.1.06 AND lt;1.4.06 then for the sum range the correspoding values for
each
gt; date entry. however i justy keep getting an error. Any of you genius' out
gt; there got any ideas please
gt;
gt;
Arristabryan,

Sounds like a good use for a pivot table.

hth,

Dougquot;Arristabryanquot; gt; wrote in message
...
gt;I have a sheet for my small business. I want to sum all purchases that have
gt; occurred between two dates i.e. each quarter. I have tried using SUMIF
gt; then
gt; specifying for range the date entered, then for the criteria I used say
gt;gt;1.1.06 AND lt;1.4.06 then for the sum range the correspoding values for each
gt; date entry. however i justy keep getting an error. Any of you genius' out
gt; there got any ideas please
gt;
gt;