Using the AVERAGE function with IF.

[James8761]

Hi,
I have a lot of data in Column I, which relates to %'s. In Column F, I have data relating to the amount of times a participant took part in a race.

I want to do an average of Column I. So normally I'd just put in =AVERAGE(I:I). However, I only want to get an AVERAGE of people who have took part in 6 or more races. (That data is in Column F).

Could someone explain how I could do that please?
Kind regards,
J

 

[sapionapio]

hello
you could use an IF...
IF ( F value > 6, F value , "-") on the empty column example G and in H column =AVERAGE(G:G)
have I explained myself?

 

[JimM]

How about

=AVERAGEIF(F2:F100,">=6",I2:I100)

Obviously change the data ranges to suit

 

[James8761]

How about

=AVERAGEIF(F2:F100,">=6",I2:I100)

Obviously change the data ranges to suit

That's sorted it. Thanks very much Jim.

 

[James8761]

Thank Sapionapio, that also works.

 

[sapionapio]

OUCH
sorry James I had completely forgotten the existence of AVERAGEIF!!!