Using the AVERAGE function with IF.

James8761

Board Regular
Joined
Apr 24, 2012
Messages
133
Office Version
2019
Platform
Windows
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
 

Some videos you may like

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
Joined
Oct 25, 2019
Messages
7
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?
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
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...
Top