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:
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.
Bookmarks