I am trying to set a COUNTIF formula. I have already done this for column C
and it works but now i want to set a formula so that if column c contains
"sick" or "medical" it should then look to column D and tell me the number
with "sick" or medical" in column C that have the result "referred to
manager" in column D.

C
Medial
Sick
Leave

D
Referred to Manager
Returned to Manager