Results 1 to 5 of 5

Average IFS with Multiple Criteria AND Multiple Dynamic Columns

Threaded View

  1. 05-26-2020, 10:50 AM #1
    MarkoGreenio
    MarkoGreenio is offline
    Forum Contributor
    Join Date
    06-18-2013
    Location
    Barnsley
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    104

    Average IFS with Multiple Criteria AND Multiple Dynamic Columns

    Hi all,

    I am having a problem solving this so I hope you can help and attached the sheet with the result FYI.

    I would like an average of a number that is in multiple columns and using multiple criteria, the attached spreadsheet explains better.

    Thank you in advance

    Mark
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Average, Median, multiple criteria, unique values, dynamic worksheet
    By branchoff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2016, 12:04 PM
  2. [SOLVED] Need to establish an average across multiple columns where multiple criteria met
    By steeler11111 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-30-2016, 06:01 AM
  3. Trying to find median & average for multiple columns with multiple criteria
    By help-meplease in forum Excel General
    Replies: 1
    Last Post: 02-15-2016, 04:35 PM
  4. 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
  5. Average with Multiple Criteria and on Different Columns
    By noskcire24 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-12-2015, 09:01 PM
  6. 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
  7. Average of Data with Dynamic Multiple Criteria
    By Hudas in forum Excel General
    Replies: 2
    Last Post: 04-08-2012, 07:27 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1