| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I count 2 columns of data that meet a certain criteria?
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). |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count 2 columns of data that meet a certain criteria?
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 "RonJon" wrote: 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). |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count 2 columns of data that meet a certain criteria?
That does it. Thanks
"Ron Coderre" wrote: 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 "RonJon" wrote: 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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if two columns match different criteria | Excel Worksheet Functions | |||
| Count Cells that meet Criteria | Excel Worksheet Functions | |||
| How to count data in 2 columns | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| How do I count data in range A:A that is dependent upon criteria . | Excel Worksheet Functions | |||
Hybrid Mode
