How to make a COUNTIFS Formula work
Hello, I'm hoping someone might be able to help me make a COUNTIFS formula work. Some background... I've set up a sheet that aims to capture a team's availability of staff in any given month, should their be a major event occur. The staff would complete a form that asks for their name, contact details, job role and their availability for that month - each form/sheet has columns for each day of the month and then they answer Yes/No/Maybe to each day of the month.
I'm trying to set up a COUNTIFS formula in the sheet summary to work out the total number of staff for each role for the whole month. I've done a screenshot of the sheet for your reference below:
I thought the formula would work as follows:
=COUNTIFS([Role:Role], "Audio News Domestic", [1st February]:[28th February], "Yes")
but it doesn't seem to like it, as it's coming up with an UPARSEABLE error message.
Any ideas how I can get it to work?
Help Article Resources
Check out the Formula Handbook template!