# Using the AVERAGE function with IF.

#### James8761

##### Board Regular
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

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### sapionapio

##### New Member
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

##### Well-known Member

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

Obviously change the data ranges to suit

#### James8761

##### Board Regular

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

Obviously change the data ranges to suit
That's sorted it. Thanks very much Jim.

#### James8761

##### Board Regular
Thank Sapionapio, that also works.

#### sapionapio

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

1,106,176
Messages
5,509,615
Members
408,744
Latest member
Punweet Singh

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...