Well if each participants input a range, I guess the answer should also offer a range so you do the average of each min and each max and say the average is between avg(min) and avg(max). Else if only some people answered a range, than I would select the median value. With a Weighted Average, one or more numbers is given a greater significance, or weight. Find a Weighted Average. Use the SUMPRODUCT and the SUM functions to find a Weighted Average, which depends on the weight applied to the values. For example, a shipment of 10 cases of pencils is 20 cents per case.

How to average multiple vlookup findings in Excel? For example there are many values matched the lookup value in your table, and you want to average all vlookup findings (target values) in Excel, how could you calculate the average quickly? The following table gives the formulas for average problems: Weighted Average, Mean, and Average Speed. Scroll down the page for examples and solutions. Weighted Average Problems. One type of average problems involves the weighted average - which is the average of two or more terms that do not all have the same number of members.

How to average multiple vlookup findings in Excel? For example there are many values matched the lookup value in your table, and you want to average all vlookup findings (target values) in Excel, how could you calculate the average quickly?

May 23, 2017 · In the next article, we will discuss a couple of formulas find weighted average in Excel and you might be surprised to know that it's much easier than it sounds. I thank you for reading and hope to see you on our blog next week! You may also be interested in: How to calculate weighted average in Excel; How to calculate moving average in Excel Because your data set has a large number of items with a finite number of values. Because the value you are trying to calculate is made up of categories which each have different weights. Using the attached tableau workbook – is there a way to calculate the weighted average life of the dollars? I would think of this in Excel terms as: Sumproduct(Period Index * Dollars)/Sum(Dollars)/12 I get the message “cannot mix aggregate and non aggregate arguments to function” when trying to set this up in “Sumproduct”.