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.

To read the rest of the article you'll need to log in below

If you've forgotten your details click here for a reminder.

If you haven't got an account, it's free to set up and only takes a minute,
click here to register

Create your free account

  • Access all articles in full
  • View multimedia
  • Receive email bulletins
  • Private messaging
Register now

Login

Forgotten your password?

Any Answers theme of the month

Latest questions on
Preparing for 2010/11
- payroll & tax planning advice:

Overseas director and PAYE / NIC

Directors and NIC

P46(Car) - what are the rules?

No PAYE scheme but P11d may be needed

IT Zone today

Apple iPhoneGadget blog
Latest news from CES

Snow strategy:
Work remotely

SA songs
Listen to our Spotify list!
 

Download library

Free downloads
Check out our library of podcasts and tutorials.