how to return multiple counts using countif?
I have a column with the results of a survey "very interested", "interested", "moderate interest", and "Not interested". I am trying to use Countif in an aggregate formula to return the count of each of those in a summary report. I can get one category to show a count but can not work out how to extend the formula to show a count for each result. Are you able to use a multiple countif in an aggregate formula. If not then what is another way to achieve the result.