Rolling Percentage Complete Formula...

[radar2000]

Hi everyone.

Could someone help me out with a rolling percentage complete formula.

For example.

If cells A2, A3 ,A4 contained the following percentages (25%, 50%, 60%) I need the overall result to be displayed in cell A1.

Now I know it's as simple as creating the following formula in A1:

=(A2+A3+A4)/3

Here's the tricky part (well maybe for me ). If in the future I needed to add additional percentages within A2, A3 ,A4. For example A2, A3 ,A4, A5, A6 (25%, 50%, 60%, 45%, 30%) the variable that I divide with will need to change from 3 to 5 ( =(A2+A3+A4+A5+A6)/5 ).

Can this formula be modified to roll with the additional entries if I ever needed to add them?

Hope this makes sense.

Thanks.

 

[radar2000]

I think I may have figured it out.

I used the following formula...

=SUM(A2:A4)/COUNT(A2:A4)

Seems to do what I need it to do

Just in case anyone is curious as to what I needed this formula for, I'm a Project Manager and I regularly create project timelines / critical paths for our internal project team as well for our clients. I usually create these in Microsoft Project, however, most of my clients don't use Microsoft Project...therefore, I need to create these in Excel.

You will note that in Microsoft Project, you can keep track of Percentage of Work completed for each task(s). Hence the reason I needed this formula.

Anyways, I'm going to plug in this formula and will see if works through out the rest of the document.

Thanks.