Results 1 to 5 of 5

Average IFs multiple criteria issues

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-25-2013
    Location
    near Philly, PA USA
    MS-Off Ver
    Excel 2019
    Posts
    182

    Average IFs multiple criteria issues

    In the attached sample, in the pink cells, I'm attempting to take the average values of the blue shaded area depending on the values in the yellow shaded area.
    For example, for all Pretreatment values between a range, what is the average Treatment values associated with them.
    I think I have some of the pink Pretreatment values right but not the Treatment values.

    I appreciate the help!
    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. sum if issues with multiple columns of criteria
    By mandzrose in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2020, 02:59 PM
  2. Index Match Formula with multiple criteria Issues
    By alogia67 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-29-2020, 09:44 AM
  3. Average based on criteria and multiple criteria
    By batchjb69 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-05-2016, 04:30 AM
  4. [SOLVED] Excel formula nested functions max, if, and multiple criteria issues
    By Jack7774 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2016, 04:38 PM
  5. Replies: 1
    Last Post: 02-15-2016, 04:35 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. Replies: 3
    Last Post: 07-02-2012, 06:52 PM

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