• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Rolling progress of averages (?!)

L

Luppy

New Member
Hello there,


I was just wondering if anyone could help with my problem as I’m making myself ill trying to resolve it!


I have a row of manually entered averages in E56:Q56.

I would like to show what the subsequent (rolling)average for each cell is e.g.E56 = 80%, F56 =E56+F56, G56 = Result of E56+F56+G56 and so on.

In the last cell R56 I would like to show a summary of the totals.


I’m sorry if it doesn’t sound clear but at the moment in R56 I have an average of averages but this is not what my Manager wants!


Many thanks in advance for any help that you can give,

Kind regards, Jan.
 
As discussed before, Average of average is wrong. It gives a false answer.(not the real Average) Google it and check it out.


Secondly, what are you averaging? Percentages? whole numbers?
 
Hi, Luppy!


Give a look at this post for further information:

http://chandoo.org/forums/topic/average-of-averages#post-23512


Regards!
 
You must log in or register to reply here.
Back
Top