It'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.


