I cannot seem to take an average of numbers in cells on other sheets. Cell A1 on

Question

I cannot seem to take an average of numbers in cells on other sheets. Cell A1 on sheet1 contains the number 1 Cell A1 on sheet2 contains the number 2 Cell A1 on sheet3 contains the number 3 Cell A1 on sheet4 contains the number 4 Cell A1 on sheet5 contains the number 5 Sheet1 Cell A2 contains ='1'!A1+'2'!A1+'3'!A1+'4'!A1+'5'!A1 and gives 15, as expected. However, Sheet1 Cell A3 contains =AVERAGE('1'!A1+'2'!A1+'3'!A1+'4'!A1+'5'!A1) and gives 15 instead of 3. What is happening and how do I fix this?

Thanks !!

Explanation / Answer

Hi..

My post disappeared!!!

What's happening is that your formula is taking the average of 15 which is 15. Try it this way

=AVERAGE('1'!A1,'2'!A1,'3'!A1,'4'!A1,'5'!A1);

or much simpler providing the sheets are in order with no intervening sheets between 1 & 5

=AVERAGE('1:5'!A1)

EDIT. My other post re-appeared so I deleted it.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.