Hi,
Is the below possible to do please?
JOE, 12, Sickness
JOE, 11, Authorised
DAVE, 14, Sickness
DAVE, 14, Sickness
DAVE, 10, Authorised
Count how many Total Instances Sickness for JOE (1)
Count how many Total Instances Authorised for JOE (1)
Count how many Total Instances Sickness for DAVE (2)
Count how many Total Instances Authorised for DAVE (1)
I tried =COUNTIFS(A1:A5,"JOE",C1:C5,"Authorised",B1:B5) but it displays #NAME?
Thanks in advance for any help!
Bookmarks