- Premier Knowledge Base
- Premier Crop Systems Software Training
- Tips and Tricks
How to Create Weighted Averages in Excel
Click in the desired cell to display the average.
In the Formula Bar, use the "SUMPRODUCT" function.
When you start typing, a list of corresponding functions will appear. Double click on the desired Function to select it.
Select the values that you want to average by clicking in the first cell with values and dragging the selection box to the last cell of values.
Add a ",".
Select the acres for the corresponding values.
Complete the Function by inserting a ")".
Now you will want to divide by the acres by typing in a "/".
Insert the Function of SUM.
Add a "(", select the acres values, and close the function with a ")".
Click the Enter key and your weighted average will display.
