Avg multiple cells in multiple sheets - Excel

Question

Avg multiple cells in multiple sheets - Excel

[Solved/Closed]

Report

FarmersDaughter1680 - Oct 5, 2011 at 01:43 PM
FarmersDaughter1680 - Oct 6, 2011 at 04:26 PM

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!

Avg multiple cells in multiple sheets - Excel
Apply formula to multiple sheets excel - How-To - Excel
Split sheet into multiple sheets excel ✓ - Forum - Excel
Copy data from one sheet to multiple sheets excel vba - Forum - Excel
Excel vba rename multiple sheets based on cell value - How-To - Excel
Excel Macro: Rename all Worksheets ✓ - Forum - Excel

2 replies

Answer 2 / 2

FarmersDaughter1680
Oct 6, 2011 at 04:26 PM

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

Ask a question

TrowaD · Accepted Answer · 2011-10-06T10:16:41-0400

Answer 1 / 2

TrowaD

Posts: 2805
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: September 14, 2021

481
Oct 6, 2011 at 10:16 AM

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

Avg multiple cells in multiple sheets - Excel

2 replies

Your reply

Subscribe To Our Newsletter!