Results 1 to 4 of 4

Averaging formula with multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    02-10-2021
    Location
    London, England
    MS-Off Ver
    MS Excel for Mac version 16.44
    Posts
    2

    Averaging formula with multiple criteria

    Hello,

    I would like some help with averaging cell values according to two criteria. Please find an example file attached.

    Criteria:
    1. Exclude all values between 0 and 0,2. I think I have found the solution for this, for example: =AVERAGEIFS(B6:B10;B6:B10;">=0,2").

    2. Calculate average speed in column B for each Player in column A automatically.
    Each player has an ID number. I would like to average the speed for each player automatically for a big data set with 800 players but cannot figure out how because each player has a different number of entries. So, in other words, I would like Excel to pick the range in column B in the AVERAGEIFS function above according to the Player ID in column A.

    Thank you very much in advance for your time and help!
    Lot
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Averaging Cell with Multiple Criteria plus Forced Minimum Values
    By CraigsWorld in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-20-2018, 12:23 AM
  2. Help: I need a way to combine these 3 criteria into one averaging formula.
    By tacomcnacho in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2015, 11:55 PM
  3. Formula for Averaging Array Given Multiple Criteria
    By celestealexandra in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2014, 11:56 AM
  4. Formula help (averaging multiple columns)
    By xceller8 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 07-06-2013, 10:06 PM
  5. Help please excel 2003 formula- averaging with criteria
    By paulsmyl in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-03-2013, 02:30 AM
  6. Formula for Averaging multiple cells on multiple pages
    By blakeandsteph in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-24-2013, 09:34 PM
  7. VBA Loop for averaging multiple cells adjacent to date criteria column
    By Swampy79 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2013, 10:08 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1