Hi everybody

I'm not entirely sure if this is where I should post but It seemed the most relevant. Some friends and I are finishing up on our MSc degree in the UK and we naturally want to find out our grade average. I've put together an Excel sheet which calculates how many credits of each module we take we've obtained. However I've only managed to provide a sum of credits we currently have and not what our overall average is or what marks we need to get on our remaining assignments to get a desired final grade.

https://www.dropbox.com/s/5gqwxm7c1b...%20System.xlsx

Above is a link to the excel sheet. Could someone help me work out a formula to calculate the % value of each module and also how to calculate the average of our grades? I have to admit I normally hate maths and putting this together was the result of procrastinating instead of studying for finals!

Renz