How to calculate the average as per group in MS Excel-CodePudding

As per below table how to calculate the average calls made by visitor per region in MS Excel.

CodePudding user response：

If you have the newest version and want to stick with formulas:

=LET(x, UNIQUE(region_range),
y, AVERAGEIF(region_range, x, call_range),
IF(SEQUENCE(1,2)=1,x,y))

For example:

But pivot tables as recommended by @Ron Rosenfeld are likely faster. It would be a good idea to become familiar with them for possible future use in my opinion, as they can be handy for a variety of different situations.

CodePudding user response：

You can use a Pivot table.

A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. A PivotTable is especially designed for: Querying large amounts of data in many user-friendly ways.

If you want to know morea about pivot tables please follow this Link

If you want to learn how to use pivot tables please follow this link

i hope this information can be useful for you.