Purpose:
This function calculates averages based on a customizable grouping column.
Calculation formulas are exported to a new worksheet.
The averages will be automatically updated once source data are modified.

This function can also be used for other aggregates, such as “STDEV”, “MIN”, “MAX” and “SUM” etc

Start:
Select a range on the worksheet.

Click PetroPlot --> Multiple Average.

Input the grouping column & formula:

Result: (Notice that the formula instead of a value is entered in a cell.)