+ Reply to Thread
Results 1 to 6 of 6

Average results based on multiple conditions and by month

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2007
    Posts
    6

    Average results based on multiple conditions and by month

    Hi There

    I have a data set that contains dates, a manager name and a score (and additional information that isn't relevant). I'd like to create a formula that will summarise these results by month, manager name then average the scores.

    Date Assessor COMPLIANCE
    14-Aug-13 name 1 70
    16-Aug-13 name 2 85
    1-Jul-13 name 3 90
    22-Aug-13 name 1 100

    for example the Aug-13 average compliance score Name 1 is 85

    I usually get around the date issue by creating a separate column, that vlookups to a month. But as i'm advancing in my knowledge, i'd like to elimate having to add this column and create a single formula

    Thanks all

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Average results based on multiple conditions and by month

    Have a look at the highlighted cells in this workbook and see if it suits your needs. Note that this uses an array formula, which needs to be entered using Ctrl + Shift + Enter instead of just Enter.

    Hope it helps

    Please don't forget to mark this thread as solved and add some reputation to me if I have answered your question.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Average results based on multiple conditions and by month

    Sorry, actually try this one instead, as I forgot to make sure that it was the same year in my first response.

    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-14-2013
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Average results based on multiple conditions and by month

    Thank you so much!!! Perfect

  5. #5
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Average results based on multiple conditions and by month

    You're welcome. Please don't forget to mark this thread as solved.

    Have a great day

  6. #6
    Registered User
    Join Date
    08-14-2013
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Average results based on multiple conditions and by month

    Oh yeah, will do

    You have a great day too

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for average duration for each month based on the ending month
    By bobby769 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-21-2013, 11:18 AM
  2. [SOLVED] Quite Complex Average based on multiple conditions
    By ryanmanc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-22-2013, 05:59 AM
  3. [SOLVED] Returning only unique results based on multiple conditions
    By Dickens153 in forum Excel General
    Replies: 5
    Last Post: 03-29-2012, 12:29 PM
  4. Average based on multiple conditions
    By kostas in forum Excel General
    Replies: 1
    Last Post: 03-27-2010, 07:00 PM
  5. Replies: 1
    Last Post: 03-12-2009, 06:33 AM

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