Calculating Percentage Averages in Excel

[DANIEL 602]

Hello,
I want to calculate the averages of several derived percentage values. However, in some cases the percentage is over 100%.
Excel
What I want to do is calculate the real average - discarding any value over 100%. For (very simple) example:

Average of these values

100%+80%+120%/3 = 100%

The real average of these values should be:

(100%+80%+120%)/3 = 93.33%

is there any function in to do it ?

Thank you

[ThoMas321]

I don't think I've heard about what you refer to as a "real average" I just can't figure out how to get 93.33% out of 100% and 80% - did you accidentally use 280/3 instead of 180/3 ?

[JonathanD]

if you enter this formula

=AVERAGE(IF(A3:A5>1,1,A3:A5))

then in the formula bar do it with CTRL+SHIFT+ENTER so it will become an array formula then you'll get the 93% you're looking for.