counting
Try this:
=Sumproduct((A1:A5="Elective")*(B1:B5="Yes"))
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"JRD" wrote in message
...
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.
|