Average for Percentage.

[Robin Chapple]

I have a column of percentages that I need to average but one record
needs to be omitted.

I am using: =AVERAGE(H2:H40)

I need to ignore the value in H6

How do I do that?

Thanks,

Robin Chapple

 

[Aladin Akyurek]

=AVERAGE(H2:H5,H7:H40)

 

[Don Guillett]

one way, maybe. Extra () for emphasis
=(sum(h2:h40)-h6)/counta(h2:h40)-1

 

[Robin Chapple]

Thanks Aladin,

I was close! I tried =AVERAGE((H2:H5)(H7:H40))

A mile away. <G>

Cheers,

Robin

 

[John K]

Hope your data is all the same. Otherwise you won't get
an accurate average. If on % is based on a total of 2
with 0 to give you 100% and 2 other % is based on 100
each and 1 has 10 giving you 90% and the say 88%.
Averaging the % will be different that adding the totals
and getting the % from those numbers. Of course if you
only have the percentages then you have no choice. But
if you're getting the percentages from 2 other columns
then sum those to get you percentage.

John