Avg multiple cells in multiple sheets - Excel

[Solved/Closed]
Report
-
 FarmersDaughter1680 -
Hello,
I need to average multiple cells across multiple sheets, but not all are in the same column/number. I need to average B35,D35,F35 in Sheet 1, Sheet 2, and Sheet 3, and B39,D39,F39 in Sheet 4. I want the answer to appear in a designated cell in Sheet 5. How do I write this formula?

Thanks!


2 replies

Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
481
Hi FarmersDaughter1680,

Here is your formula:
=AVERAGE(Sheet1!B35,Sheet1!D35,Sheet1!F35,Sheet2!B35,Sheet2!D35,Sheet2!F35,Sheet3!B35,Sheet3!D35,Sheet3!F35,Sheet4!B39,Sheet4!D39,Sheet4!F39)

Type this formula in your designated cell in Sheet 5
.
Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month


Thank you TrowaD!
This is a workable solution for me!