A
amyr
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.
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.
10 = "Amy"),--(E1:E10="Gowns"),(F1:F10))