J
JRD
How do I count the number of cells in column A that contain a certain string
but only if the same row in column B contains a certain string
eg
A B
Elective Yes
Elective No
Urgent Yes
Urgent No
Elective Yes
How do I count the number of rows that contain Elective in column A and Yes
in column B. The answer here would be 2.
but only if the same row in column B contains a certain string
eg
A B
Elective Yes
Elective No
Urgent Yes
Urgent No
Elective Yes
How do I count the number of rows that contain Elective in column A and Yes
in column B. The answer here would be 2.