Hi,

Cell A2:A100 contains a dropdown list (choice of six Sites)
C2:C100 to I2:I100 contains hours worked at the relevant site (by day)
Each of the rows relates to a different person.
I am trying to count the number of people working at each site each day

I have tried IF, DCOUNT, COUNT, FREQUENCY etc. with no success.

Has anyone any suggestions, please?