I am on working on a sheet with month, region, country number , number of CSAT, and CSAT total responses, in this case, the average would be the Number of CSAT/ CSAT Total responses and I am looking to have Average CSAT score per month by region, I was thinking of creating a new column with AVG already calculated but would there be a better way to approach the question?

CodePudding user response：

A pivot table should be more suitable.

In H1, create a pivot table.

solution #1

In L1,

={"Average";arrayformula(if(K2:K>0,J2:J/K2:K,))}

solution, #2

add a calculated field in your pivot table with this formula

=iferror('Number of CSAT ''Yes'''/'CSAT responses')