adding up several different criteria
 

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1

adding up several different criteria
 

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

--
HTH

Bob Phillips

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

"s2m via OfficeKB.com" <u23063@uwe wrote in message
news:62020157524b0@uwe...
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1

adding up several different criteria
 

THANK YOU AGAIN!!

Bob Phillips wrote:
=SUMPRODUCT(--(A2:A20="Apple"),--(B2:B20="small"),--(C2:C20=--"2006-06-15")
,--(C2:C20<=--"2006-06-16"),--(D2:D20=--"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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1