Compute an Average by category

Here is my formula
=IF(ISERROR(AVERAGE(IF(F5:F112<>0,F5:F112,""))),0,AVERAGE(IF(F5:F112<>0,F5:F112)))

It calculates an average that is not 0 and not an error - works just
fine.
Each of the rows is also a member of a category
ECP, ROM, REA etc

Is there a way I can calculate the average of each of them separately
by setting a filter?

Thus, if I filtered on ECP, then the average calculated would be only
for ECP.

Is that possible without a macro?

Glen

.

Loading