How To Get Weighted Averages In Excel. To complete the weight average computation, you’ll have to combine the first and the last half of the weighted average formula: The concept of an average comes from mathematics, average can be defined as the result obtained by adding several quantities together and then dividing this total by the number of quantities.

Remember to close the parentheses after the argument: Introduction to weighted average in excel. But we have count of values.