+ Reply to Thread
Results 1 to 3 of 3

Averageifs

  1. #1
    Forum Contributor
    Join Date
    11-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    225

    Averageifs

    Dear Excel Forum

    Please help on on some clarrification on average ifs. My question is I expect J16 CELL SHOULD BE SAME AS J22 CELL. P23 should be same as m23 and J16 should be equal to M16. M2 should be equal to J2. But why it did not happen.

    Please help me if possible.

    Thanks
    Shams
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Averageifs

    The result is right.
    the values shall not be the same.

    The values would be the same basically only (excep of some other very special cases) if number of each records for each year would be the same.
    See this:
    if you take
    2001 100
    2001 100
    2001 100
    2014 1000
    then avg for 2001 is 100 and for 2014 is 1000 avg of this two is 550 while avg for all deta is 325 - right?

    of course for data
    2001 100
    2001 100
    2014 1000
    2014 1000

    anyway you calculate avg - it is always 550


    so avg of all data
    and
    avg of avgs of subsets of different quantities
    shall be in almost all cases different
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    11-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    225

    Re: Averageifs

    Dear Kaper

    Thank you very much for cool explanation. It makes sense now.

    Shams

+ 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. Averageifs.
    By lokpal.panwar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2014, 07:09 AM
  2. [SOLVED] averageifs help!
    By tgosman in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-30-2013, 09:34 PM
  3. [SOLVED] MIN and MAX like an AVERAGEIFS?
    By superchill435 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-10-2012, 09:06 AM
  4. AverageIfs
    By DMAN11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-07-2010, 05:31 PM
  5. Averageifs
    By rwtrader99 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-10-2010, 03:26 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