Download Now: Free Content Marketing Planning Kit

[hoxesi8100@]

To calculate the weighted average in Excel, use the SUMPRODUCT and SUM functions in the following formula:

=SUMPRODUCT(X:X,X:X)/SUM(X:X)

This formula works by multiplying each value by its weight and combining the values. Then, you divide the SUMPRODUCT by the sum of the weights for your weighted average.


Still confused? Let's go over the steps in the next section.

Using SUMPRODUCT to Calculate Weighted Average in Excel
Here are my steps for using SUMPRODUCT.
How to Run a Content Audit in 2025 (With Tips From Content & SEO Specialists)
Download Now: Free Content belize phone number material Marketing Planning Templates
Kayla Carmicheal
Kayla Carmicheal
Updated: December 30, 2024

Published: December 22, 2016

It’s not enough to make content. You have to make sure what you make is performing well. That’s where content audits come in.

man performs content seo audit for a blog

As a content marketer, I rely on content audits to keep track of how content is performing, understand what needs improvement, and use analytics to inform future campaigns.