Adding up several Percentages in cells

[Newbienew]

So I have a few cells that have have 100% in them. At the end of the column I want a over all precentage of the percentages. So im trying to do this

100%
100%
100%
100%
100%
100%

Total 100%

So if the precentage changes then the overall total percentage changes


80%
100%
90%
26%
10%
100%

Total ???%

I have know clue on have to make this happen. Thank You in advance

 

[DeBeuz]

Re: Adding up several Precentages in cells

Hi,

You could try using the average function over the range of percentages.
Whether that is valid math, depends on how the percentages are calculated.
You can not always simply add the % up and divide by the number of %!

Usually % = *(a / b) * 100
A better approach might be (sum(a1:a5)/sum(b1:b5)) * 100.

Succes,
Paul

 

[Newbienew]

Re: Adding up several Precentages in cells

Thank You soooo much