Average for Percentage.

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

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
 
Thanks Aladin,

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

A mile away. <G>

Cheers,

Robin
 
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
 
Back
Top