count criteria.xlsx
Hi there
I'm looking for help with the attached
I have a sheet of data which is broken down by day and for multiple resources, each row may contain more than one type of activity, I need to count up the resource types across the month and put them into a table by month.
I have tried COUNTIFS but either it's not up to the job or I can't work out how to do it.
I can do the first step of getting a count for any type of activity using SUMPRODUCT but have to specify the row in the formula whereas I want it to select the row based on the resource type.
It must be possible but I don't have the skills to know how :-)
Any help appreciated.
Norfolk_lass
Bookmarks