Formula
 

I need help with a formula. My excel sheet is looking at Quality on
production. In Cell D is Quality Person (there are 50) and Cell E is the
product they are checking. I need an formula that looks at Cell D and then
counts the individual products for the Quality Person.

Example Amy Checked 26 Gowns, 2 Towels, 0 Supplies and Emily checked 2
Gowns, 1 Supplies, 0 Gloves.

Formula
 

Try something like this

=sumproduct(--(D1:D10 = "Amy"),--(E1:E10="Gowns"),(F1:F10))

D is quality person
E is product
F is the number of the product.
--
HTH,
Barb Reinhardt



"amyr" wrote:

I need help with a formula. My excel sheet is looking at Quality on
production. In Cell D is Quality Person (there are 50) and Cell E is the
product they are checking. I need an formula that looks at Cell D and then
counts the individual products for the Quality Person.

Example Amy Checked 26 Gowns, 2 Towels, 0 Supplies and Emily checked 2
Gowns, 1 Supplies, 0 Gloves.

Formula
 

Thanks Barb - but all I'm using is two columns, so I need folumn E to count
the products.

"Barb Reinhardt" wrote:

Try something like this

=sumproduct(--(D1:D10 = "Amy"),--(E1:E10="Gowns"),(F1:F10))

D is quality person
E is product
F is the number of the product.
--
HTH,
Barb Reinhardt



"amyr" wrote:

I need help with a formula. My excel sheet is looking at Quality on
production. In Cell D is Quality Person (there are 50) and Cell E is the
product they are checking. I need an formula that looks at Cell D and then
counts the individual products for the Quality Person.

Example Amy Checked 26 Gowns, 2 Towels, 0 Supplies and Emily checked 2
Gowns, 1 Supplies, 0 Gloves.