Percentage addition

Hello,

=(60% + 95% + 60%)/3

if your percentages are in A1, A2, and A3 for example
=SUM(A1:A3)/3

if the number of percentages is variable, you can replace /3 with

=SUM(A1:A30)/COUNT(A1:A30)

A+
Mike-31

A period of failure is the perfect time to sow the seeds of knowledge.

It is incorrect to say that:

10% + 20% = 30% because 10% + 20% = 30 points

The addition of percentages gives an answer in "points" and not in "percentages". You will see that in surveys, for example, it is said that the popularity of X has decreased or increased by Y point(s). This comes from this calculation.

Hello kiwi74.

It's normal for you to receive such different answers, as your question is ambiguous and incomplete.
Julien41's question is essential, and we await your response so we can provide you with the right solution.
Mike-31's proposal is correct if your question is "For my 3 trips, I used 60% the first time, 95% the second time, and 60% the third time of my gas tank; what was my average consumption?"; and the solution is (60%+95%+60%)/3, which is 71.7% of the tank's volume per trip.
dobo69's suggestion is related to the example he took. If you withdrew 60% of the savings you had at the Caisse d'Epargne, then used 95% of that amount to buy computer equipment, of which a computer represents 60% of that purchase, the computer cost you 60%*95%*60%, which is 34.2% of your savings.
As for Balario's suggestion, it doesn't correspond to anything I've learned, but maybe he can justify his explanation to us...

--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂

Hi!

It depends on the cases...
What percentage are we talking about?

Best regards,
Julien.