List of presence

Hello,

I am trying to join 2 formulas which are not working together but seperatly.

It's the countifs, I need to count for example in all the days in august, how many people were present.

I made a dropdown list with months so we can select the according month we want to see.

The current function is : =COUNTIFS(Q6:CD6;">="&B12;Q6:CD6;"<"&EDATE(B12;1);Q8:CD56;"P")
I get Value error

The ranges have to be the same size. Your final range is Q8:CD56

Hope this helps.

Pete