Calculating the average of multiple rows in Excel can be a daunting task, especially when dealing with a large dataset. In this guide, we’ll walk you through the steps of averaging multiple rows, using a simple example.
Let’s say we have a dataset of wings that were tested during class. We have calculated the average for each flight, and now we want to calculate the total average for each type of wing. We have DeltaWing, elliptical wing, and straight wing.
To calculate the total average for each wing type, we’ll start with the DeltaWing. We need to calculate the grand total for Delta. To do that, we’ll put our cursor in cell O36, and type “=”. Then we’ll select “AVERAGE” and click on our last flight in row 335. Holding down the left-click, we’ll select all the rows we need, up to row 320 in column E. We’ll press “Enter” and now we have calculated the average for our DeltaWing totals.
Next, we’ll do the same for our elliptical wing. We click on the cell next to elliptical wing totals, type “=”, select “AVERAGE” and click on our very last flight. We’ll scroll up without unclicking and select all the data we need. Once we have it all selected, we press “Enter” on our keyboard. We repeat the same process for our straight wing totals, and for the last wing type.
Now we can clearly see the average for each wing type. DeltaWing has an average of 23.7, elliptical wing has an average of 25.3, and straight wing has an average of 23.9. By using this method, we can easily calculate the average for multiple rows in Excel.
In conclusion, calculating the average for multiple rows in Excel can be made simple by following a few easy steps. With these steps, you can easily calculate the grand total for any type of data, regardless of the size of your dataset.