+ Reply to Thread
Results 1 to 2 of 2

Finding an average from two different worksheets

  1. #1
    Registered User
    Join Date
    06-20-2016
    Location
    Wisconsin, USA
    MS-Off Ver
    365 ProPlus
    Posts
    44

    Finding an average from two different worksheets

    I have an excel doc with two different sheets in it. Within each sheet there is an AVERAGEIFS function that calculates an average based on the data within that worksheet. The formula is seen here and is the same for both worksheets:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I'd like to create a 3rd worksheet in the Excel doc that contains the average of these two averages. I know that as a general rule of thumb, you aren't supposed to just add together the two averages and then divide by 2. So how could I adapt the AVERAGEIFS function that is the same for each worksheet (the only difference is they're on different worksheets) to give me the average of those two averages, that I could put in the 3rd worksheet?

    Thank You.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,717

    Re: Finding an average from two different worksheets

    I think in this case you have to roll your own:

    =(SUMIF(Sheet1!$F:$F,">="&DATE(1985,1,1),Sheet1!$L:$L)+SUMIF(Sheet2!$F:$F,">="&DATE(1985,1,1),Sheet2!$L:$L))/(COUNTIF(Sheet1!$F:$F,">="&DATE(1985,1,1))+COUNTIF(Sheet2!$F:$F,">="&DATE(1985,1,1)))
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] finding average of two different columns
    By mike rand in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 10-10-2015, 05:13 AM
  2. [SOLVED] Help with finding an average with Sumproduct
    By fgruhlke in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-12-2015, 03:29 PM
  3. Finding A missing # From the AVERAGE
    By onyxhacker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2014, 05:56 PM
  4. Finding Average
    By JezLisle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-27-2009, 10:47 AM
  5. Finding an Average
    By dmay1102 in forum Excel General
    Replies: 11
    Last Post: 07-09-2008, 02:36 PM
  6. Replies: 8
    Last Post: 03-20-2007, 02:00 PM
  7. Finding the average time
    By Gadgets in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-31-2006, 04:06 PM

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