Hi all,
I am trying to resolve a COUNT(COLLECT) formula to gather a number of instances from a range of categories by their current activity.
In my data sheet the categories are called "Treatment" and I want to know how many instances of a particular Treatment there are by the criteria of Work Activity.
I am using a roll-up sheet to gather this information and I have managed to get a total number column populated but I would like to break down this total by category (treatment) and activity...
I have tried quite a few iterations and been unsuccessful. I thought I may need to do COUNTIFS but I am not sure if this is the appropriate solution?