How do I count 2 columns of data that meet a certain criteria?

[Guest]

I have 2 columns of data. The first column has rows with either "b", "bhs",
"g" or "ghs". The second column has rows with age #'s (like 1, 2, 3, 5, 8,
etc). I can't figure out how to count for example the number of "b"'s and
"bhs"'s that are a particular age (say 5).

 

[Guest]

Try this:

With
A1:A30 (contains your codes: b, bhs, g, ghs, etc)
B1:B30 (contains ages: 1, 3, 5, etc)

This formula count the b's and bhs's that are age 5
C1: =SUMPRODUCT((A1:A30={"b","bhs"})*(B1:B30=5))

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

That does it. Thanks

Try this:

With
A1:A30 (contains your codes: b, bhs, g, ghs, etc)
B1:B30 (contains ages: 1, 3, 5, etc)

This formula count the b's and bhs's that are age 5
C1: =SUMPRODUCT((A1:A30={"b","bhs"})*(B1:B30=5))

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP