Average count by department of non-blank values
I have a sheet (produced from a template) for which the relevant fields look like this:
The brown columns are just a visual aid to show where the weekends fell in this month (October), but potentially could have values in during other months.
What I'm trying to accomplish is a rounded (up) average count of non-blank values by department where the home department is "1". For example:
Goods In: 2
Next Day: 12
However, I can't work out how to get the COUNTIFS portion of a formula to display anything other than #INCORRECT ARGUEMENT SET when putting in multiple criteria.
Using, for example, Next Day:
=COUNTIFS(Department:Department, "Next Day", [Home department checker]:[Home department checker], "1", [1st]:[31st],
I can get this to work in individual constituent parts (or both the department & checker together), but what seems to break it is having the [1st]:[31st] range in with the rest.
Can someone point me in the right direction of where I'm going wrong?
Help Article Resources
Check out the Formula Handbook template!