Results 1 to 18 of 18

Averageifs formula used on more than 1 column to average

Threaded View

  1. 11-07-2018, 03:49 PM #1
    paolina13
    paolina13 is offline
    Registered User
    Join Date
    11-07-2018
    Location
    Bulgaria
    MS-Off Ver
    2016
    Posts
    9

    Question Averageifs formula used on more than 1 column to average

    Hello, I am trying to calculate an average of 2 columns.
    I want the yellow colums averaged on 3 criteria ranges - pink, orange and red if in those ranges there is written concrete text.
    Here is a picture of what I'm trying to do. excel.jpg

    Thanks in advance.
    Last edited by paolina13; 11-08-2018 at 05:25 PM.
    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. How to get the average of multiple averageifs with the same conditions
    By Nitty_gritty in forum Excel General
    Replies: 5
    Last Post: 10-30-2017, 10:33 AM
  2. [SOLVED] Averageifs function not returning correct average
    By CSherman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-02-2017, 11:11 PM
  3. [SOLVED] Different results for =average & averageifs for same data range
    By ljbrown in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2017, 05:49 PM
  4. [SOLVED] AverageIfs to average two ranges if match is met
    By bjnockle in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-20-2017, 04:25 AM
  5. [SOLVED] AVERAGEIFS to average times in a range if criteria met
    By bjnockle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-26-2016, 03:06 AM
  6. [SOLVED] How to get an AVERAGEIFS formula to not include cell in average, by triggering switch?
    By Carmstrong227 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-19-2013, 01:15 PM
  7. Using AVERAGEIFS function to average a smaller subset of criteria data
    By RJS5062 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-22-2012, 04:19 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1