Use Excel SUM functions to calculate weighted averages

CalculatorIt's not the most complex spreadsheet challenge, but working out weighted averages is a perennial favourite on Any Answers. Simon Hurst explains how to do it.


Apparently, one of the most frequent queries about Microsoft Excel concerns the formula for calcuating weighted averages.

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.