Results 1 to 15 of 15

Average based on Value from a different Cell but in multiple columns

Threaded View

fotodude Average based on Value from a... 10-05-2017, 12:41 PM
CAntosh Re: Average based on Value... 10-05-2017, 01:03 PM
fotodude Re: Average based on Value... 10-05-2017, 01:17 PM
JohnTopley Re: Average based on Value... 10-05-2017, 01:22 PM
CAntosh Re: Average based on Value... 10-05-2017, 01:22 PM
fotodude Re: Average based on Value... 10-09-2017, 05:14 PM
CAntosh Re: Average based on Value... 10-10-2017, 10:24 AM
fotodude Re: Average based on Value... 10-11-2017, 12:18 PM
CAntosh Re: Average based on Value... 10-11-2017, 12:37 PM
fotodude Re: Average based on Value... 10-12-2017, 11:02 AM
CAntosh Re: Average based on Value... 10-12-2017, 12:42 PM
fotodude Re: Average based on Value... 10-13-2017, 10:43 AM
CAntosh Re: Average based on Value... 10-13-2017, 12:22 PM
fotodude Re: Average based on Value... 10-13-2017, 05:09 PM
CAntosh Re: Average based on Value... 10-13-2017, 05:12 PM
  1. #1
    Forum Contributor
    Join Date
    04-29-2017
    Location
    Huntington Beach, California
    MS-Off Ver
    365 business
    Posts
    114

    Average based on Value from a different Cell but in multiple columns

    Hi Guys,
    I need some help. I'm trying to figure out to combine multiple formulas in one.
    I have a sheet where I look in column b for a value and want to calculate the average of the % in column D. So good so far but now I want to add the same thing for when I look in column F and calculate the average % in column H and so on. It would be nice if I could create that in one formula. Right now I'm doing

    =AVERAGEIF(B:B,"M",D:D) then another one =AVERAGEIF(F:F,"M",H:H) and another one =AVERAGEIF(J:J,"M",L:L) and then =AVERAGE(P2,R2,T2)

    Attached please find my sample file.
    Every help is appreciated.
    Thanks already,
    Martin
    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] Place text from multiple columns into one cell based on another columns value
    By minesht in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2015, 05:44 PM
  2. 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
  3. [SOLVED] Calculate a weighted average in a single cell based on multiple criteria
    By _Bryan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2013, 04:38 PM
  4. [SOLVED] Average Based on Criteria in Multiple Columns
    By sinspawn56 in forum Excel General
    Replies: 2
    Last Post: 07-31-2012, 01:27 PM
  5. Average multiple rows based on 2 columns
    By beaner in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-19-2011, 09:18 PM
  6. Average IF two columns (based on content of another cell)
    By garwil in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-08-2011, 12:21 PM
  7. Replies: 1
    Last Post: 03-12-2009, 06:33 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