--- title: How to Create Weighted Averages in Excel description: 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 --- [Skip to content](https://processes.premiercrop.com/knowledge/how-to-create-weighted-averages-in-excel#main-content) [Customer portal](https://processes.premiercrop.com/tickets-view?hsLang=en) ![PCS-Black-icon-1.png\]](https://processes.premiercrop.com/hs-fs/hubfs/PCS-Black-icon-1.png?width=35&height=40&name=PCS-Black-icon-1.png) - [Tickets](https://processes.premiercrop.com/tickets-view) - [Sign out](https://processes.premiercrop.com/_hcms/mem/logout) Open main navigation Close main navigation - [Tickets](https://processes.premiercrop.com/tickets-view) - [Sign out](https://processes.premiercrop.com/_hcms/mem/logout) - [Customer portal](https://processes.premiercrop.com/tickets-view) - [Go to premiercrop.com](https://services.premiercrop.com/) [Go to premiercrop.com](https://services.premiercrop.com/) What do you need help with today? - There are no suggestions because the search field is empty. 1. [Premier Knowledge Base](https://processes.premiercrop.com/knowledge?hsLang=en) 2. [Premier Crop Systems Software Training](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en) 3. [Tips and Tricks](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#tips-and-tricks) # How to Create Weighted Averages in Excel Click in the desired cell to display the average. ![cell](https://processes.premiercrop.com/hs-fs/hubfs/cell.png?width=263&height=421&name=cell.png) 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. ![sumproduct](https://processes.premiercrop.com/hs-fs/hubfs/sumproduct.png?width=688&height=570&name=sumproduct.png) 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. ![sumproduct2](https://processes.premiercrop.com/hs-fs/hubfs/sumproduct2.png?width=323&height=298&name=sumproduct2.png) Add a ",". ![comma](https://processes.premiercrop.com/hs-fs/hubfs/comma.png?width=193&height=90&name=comma.png) Select the acres for the corresponding values. ![acres](https://processes.premiercrop.com/hs-fs/hubfs/acres.png?width=396&height=301&name=acres.png) Complete the Function by inserting a ")". ![par](https://processes.premiercrop.com/hs-fs/hubfs/par.png?width=335&height=117&name=par.png) Now you will want to divide by the acres by typing in a "/". ![div](https://processes.premiercrop.com/hs-fs/hubfs/div.png?width=358&height=120&name=div.png) Insert the Function of **SUM**. ![sum](https://processes.premiercrop.com/hs-fs/hubfs/sum.png?width=379&height=167&name=sum.png) Add a "(", select the acres values, and close the function with a ")". ![finale](https://processes.premiercrop.com/hs-fs/hubfs/finale.png?width=364&height=297&name=finale.png) Click the **Enter** key and your weighted average will display. ![bev](https://processes.premiercrop.com/hs-fs/hubfs/bev.png?width=224&height=315&name=bev.png)   - [Getting Started with Premier Crop](https://processes.premiercrop.com/knowledge/getting-started-with-premier-crop?hsLang=en#main-content) - [Advisor Excel-erator](https://processes.premiercrop.com/knowledge/getting-started-with-premier-crop?hsLang=en#advisor-excel-erator) - [Premier Crop Systems Software Training](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#main-content) - [Field Management](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#field-management) - [Nutrients](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#nutrients) - [Mgmt Zones](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#mgmt-zones) - [Seed](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#seed) - [Crop Protection](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#crop-protection) - [Operations](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#operations) - [Premier Intelligence](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#premier-intelligence) - [Data Exchange](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#data-exchange) - [Reports](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#reports) - [Analytics](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#analytics) - [Dashboards](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#dashboards) - [Webinars](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#webinars) - [System Information](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#system-information) - [Tips and Tricks](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#tips-and-tricks) - [Unpublished Videos](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#unpublished-videos) - [Release Note](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#release-note) - [Analyst Studio](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#main-content) - [Getting Started](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#getting-started) - [Visualizations](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#visualizations) - [Filters](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#filters) - [Calculated Fields](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#calculated-fields) - [Exporting](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#exporting) - [Hardware & Software](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#main-content) - [Ag Leader](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#ag-leader) - [Case IH](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#case-ih) - [John Deere](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#john-deere) - [Kinze](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#kinze) - [Precision Planting](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#precision-planting) - [Raven](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#raven) - [SMS](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#sms) - [Trimble](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#trimble) - [Sales](https://processes.premiercrop.com/knowledge/sales?hsLang=en#main-content) - [Sales Resources](https://processes.premiercrop.com/knowledge/sales?hsLang=en#sales-resources) - [Partner](https://processes.premiercrop.com/knowledge/sales?hsLang=en#partner) [![Chill listening crop-3](https://processes.premiercrop.com/hs-fs/hubfs/PCS-Black-icon.png?width=21&height=24&name=PCS-Black-icon.png "Chill listening crop-3")](https://4362973.hs-sites.com/knowledge?hsLang=en) Premier Processes Copyright © 2026, Powered by Premier Crop Systems