# Rolling Percentage Complete Formula...

##### Board Regular
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.

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

##### Board Regular
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.

Replies
8
Views
106
Replies
7
Views
236
Replies
5
Views
116
Replies
3
Views
70
Replies
17
Views
364

1,195,905
Messages
6,012,229
Members
441,683
Latest member
XLGeezer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back