Results 1 to 13 of 13

Average(ifs) meeting certain criteria

Threaded View

  1. #4
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: Average(ifs) meeting certain criteria

    See attached. The formula is fairly compact, but is an array formula so if you change it you will need to press Ctrl + Shift + Enter to compute.

    You can change the number of largest by adding/subtracting items from the final array of numbers {1,2,3}.

    For your first question which I didnt see at first you could also use
    =AVERAGE(IF(($B$3&$C$3=$B$7:$B$25&$C$7:$C$25)+($C$3&$B$3=$B$7:$B$25&$C$7:$C$25),$F$7:$F$25))

    Which is also an array formula so needs Ctrl + Shift + Enter
    Attached Files Attached Files
    Last edited by Hawkeye16; 07-30-2014 at 06:36 AM.
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Average of numbers within a range meeting certain criteria
    By opal23k in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-13-2010, 06:06 PM
  2. Excel 2007 : average last 5 values meeting certain criteria
    By jrbdotcom31 in forum Excel General
    Replies: 4
    Last Post: 05-15-2010, 11:47 PM
  3. Average of numbers within a range meeting certain criteria
    By opal23k in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  4. [SOLVED] Average of numbers within a range meeting certain criteria
    By opal23k in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] Average of numbers within a range meeting certain criteria
    By opal23k in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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