formula for weighted average in excel

[noahpatterson]

completely blanking. what's the easiest way to calculate a weighted average without doing crazy long sumproduct formulas?

 

[Howard_Wolowitz]

completely blanking. what's the easiest way to calculate a weighted average without doing crazy long sumproduct formulas?

hey! yeah, sumproduct can get a bit messy if you have tons of columns. what i usually do is just make an extra column for `value * weight` for each row, then sum that up and divide by the sum of your weights. it's basically doing sumproduct but broken down into steps, sometimes easier to follow imo. works fine for me in excel/sheets.

 

[alfieturner]

completely blanking. what's the easiest way to calculate a weighted average without doing crazy long sumproduct formulas?

hey! yeah, sumproduct can get a bit messy if you have tons of columns. what i usually do is just make an extra column for `value * weight` for each row, then sum that up and divide by the sum of your weights. it's basically doing sumproduct but broken down into steps, sometimes easier to follow imo. works fine for me in excel/sheets.

oh duh a helper column is so obvious now thanks