Excel's AGGREGATE function lets you perform ... Using the same spreadsheet, your next target is to calculate the total number of goals the team has scored. One way to display totals is to check ...

n is the total number of observations. We calculate the average using Excel's "Average" function. The result, 1.32%, is in cell C65. (The exact Excel formula we use is displayed in the cell ...