I need to calculate the average of multiple cells and I want to exclude values = 0.
The cells are not sequential so I cannot use AVERAGEIF(A1:A10, ">0")
I need to individually select the cells however, I want to copy the formula across multiple columns so do not want exclude any (manually)
How do I do this?
An example of the data is seen here:
I want to calculate an average of all rows for Tier 1, Tier 2 and CBD (excluding 0)