Conditional Counting

L

Ladyengineer

I have a large spreadsheet and need to know how I can count the instances of
the number "2" in one column only when the corresponding value in a different
column is "medium". Can someone help with this?
 
R

Ron Coderre

Try something like this example:

With
A1:A100 containing sizes: large, medium, small, etc
C1:C100 containing values: 1,2,5, 100, whatever

Then...this formula counts the combinations of Medium/2

D1: =SUMPRODUCT(--(A1:A100="medium"),--(C1:C100=2))

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top