| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
want to count in two columns; countif (colA=x AND colB=y)?
I'm counting the number of occurences in a column:
COUNTIF (a1:a20,"Ontario") the answer is 8 (8 of the 20 entries in the column say "Ontario") But I want to be able to count the number of occurences in two columns: COUNTIF (a1:a20,"Ontario")... AND(b1:b20,"Ottawa") The answer should be 5 (5 of the 8 "ontario" rows include Ottawa in column b) I've tried several configurations to count Ottawa, Ontario occurences; and there is a problem with the function. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If two columns match then count one. How? Tried countif and sum . | Excel Worksheet Functions | |||
| count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions | |||
| How do I perform a "Countif" function for Two Columns? | Excel Worksheet Functions | |||
| COUNTIF With Multiple Dates, Columns and Text | Excel Worksheet Functions | |||
| Count certain changes between columns | Excel Worksheet Functions | |||
Threaded Mode
