Hi all, I hope someone can point me in the right direction here. I'm creating a simple staff form and I wish to show how many 'Sick' days they have had in a month. I know I can use the COUNTIF but this is limited to only one row on another sheet, my problem is I have multiple row for each month (12 columns with 7 rows).
For example: =COUNTIF('Staff 2023'!E4:E11,'Staff 2023'!L4:L11,'Staff 2023'!S4:S11,'Staff 2023'!Z4:Z11="Sick"), I'm aware this doesn't work, anyone have an idea how I can resolve this please?
Thank you in advance.
Bookmarks