Results 1 to 5 of 5

Average range with multiple columns and rows with multiple criteria

Threaded View

77highland Average range with multiple... 08-01-2024, 04:30 AM
JohnTopley Re: Average range with... 08-01-2024, 04:52 AM
77highland Re: Average range with... 08-01-2024, 06:27 AM
JohnTopley Re: Average range with... 08-01-2024, 06:38 AM
Czeslaw Re: Average range with... 08-02-2024, 02:36 AM
  1. #1
    Registered User
    Join Date
    10-15-2018
    Location
    London, England
    MS-Off Ver
    365
    Posts
    94

    Average range with multiple columns and rows with multiple criteria

    Hi Everyone,

    Need some help please. I need to gain an average from a range that spans multiple rows and columns based on criteria that is within different rows and columns.

    I have tried the below formula but now appreciate AVERAGEIFS cant handle this requirement without some further integrated formula?
    =AVERAGEIFS($F$6:$CH$15,$F$5:$CH$5,">="&$B$7,$F$5:$CH$5,"<"&$B$11,$E$6:$E$15,$B$15)

    Attached is a sample sheet
    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] SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple rows &
    By 77highland in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2024, 07:46 AM
  2. [SOLVED] Sumproduct Count multiple criteria with range over multiple rows and columns
    By 77highland in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-09-2023, 05:19 PM
  3. Replies: 14
    Last Post: 06-07-2021, 11:31 AM
  4. [SOLVED] Lookup multiple criteria in multiple columns in multiple rows; return true if exists
    By ufdlim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2019, 02:03 PM
  5. Replies: 1
    Last Post: 02-15-2016, 04:35 PM
  6. Trying to find median & average for multiple columns with multiple criteria
    By help-meplease in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2016, 06:59 PM
  7. Average numbers from multiple columns based on multiple criteria
    By abambi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2015, 01:52 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