J
JRD
Can anyone tell me whether there is a way to count up the number of cells in
a column that contain a specific word but only if there is a specific word in
another column e.g.
Column A Column B
1 Elective Yes
2 Elective No
3 Urgent No
4 Urgent Yes
5 Urgent Yes
I would like excel to tell me how many "urgent" in column A where "yes" is
present in column B i.e. the answer in above example would be 2.
Hope this makes sense!
John
a column that contain a specific word but only if there is a specific word in
another column e.g.
Column A Column B
1 Elective Yes
2 Elective No
3 Urgent No
4 Urgent Yes
5 Urgent Yes
I would like excel to tell me how many "urgent" in column A where "yes" is
present in column B i.e. the answer in above example would be 2.
Hope this makes sense!
John