What is the best formula to calculate a percentage average in excel?

I have a table with a column filled with percentages (positives, negatives, zeros) , for example:

-10%

5%

0%



I need a formula to calculate an average for these percentages. this can be done using a geometric media, but it does not seem to work with negatives and zeros. This is best I could find:

=POWER(PRODUCT(B51:N51),

(1/COUNT(B51:N51)))





Any help would be appreciated..!What is the best formula to calculate a percentage average in excel?
First of all, what kind of mean you want? If you want a geometric mean, that formula is already correct. However, geometric mean only applies to positive numbers. If you want to include zero and negative numbers, you have to use either arithmetic or quadratic mean.

For arithmetic mean:

= SUM(B51:N51)/COUNT(B51:N51)

For quadratic mean:

= SQRT(SUMSQ(B51:N51))

used car values

tangled dvd