adding up several different criteria

[s2m via OfficeKB.com]

I have a daily download that has information in several of the columns I need
to count.

Example
Column A: Apple, Orange, banana
column B, small, medium, large
Column C date picked
Column D: date shipped

I want to find out how many Apples, small, picked June 15th through June 16th,
shipped June 19th

Normally I would drop this into a Access and run a query, but I need to do
this in excel

Thanks for your help

 

[Bob Phillips]

=SUMPRODUCT(--(A2:A20="Apple"),--(B2:B20="small"),--(C2:C20>=--"2006-06-15")
,--(C2:C20<=--"2006-06-16"),--(D220=--"2006-06-19"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[s2m via OfficeKB.com]

THANK YOU AGAIN!!

=SUMPRODUCT(--(A2:A20="Apple"),--(B2:B20="small"),--(C2:C20>=--"2006-06-15")
,--(C2:C20<=--"2006-06-16"),--(D220=--"2006-06-19"))

I have a daily download that has information in several of the columns I need
to count.

[quoted text clipped - 12 lines]

Thanks for your help