| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count if "x" word in 1st column AND "y" word in 2nd column
Hard to explain, but here is an example:
In my first column, there are 3 options e.g.fireman, policeman and teacher. In the second column are also three options e.g. 0-5 years, 5-10 years, over 10 years. If I survey 20 people, and want to count how many firemen have worked for over 10 years, how do I work out the formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if "x" word in 1st column AND "y" word in 2nd column
Maybe
=SUMPRODUCT((A1:A36="Fireman")*(B1:B36="Over 10 years")) Mike "AGQTP" wrote: Hard to explain, but here is an example: In my first column, there are 3 options e.g.fireman, policeman and teacher. In the second column are also three options e.g. 0-5 years, 5-10 years, over 10 years. If I survey 20 people, and want to count how many firemen have worked for over 10 years, how do I work out the formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF cells(row,column) contain "this word" ??? Then return text | New Users to Excel | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| how can I count if column A="active" and column E="Job" in a list? | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
