However, this might not always give you an accurate average, which is where functions like GEOMEAN and HARMEAN come in. The ...
I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...