Avg multiple cells in multiple sheets - Excel
Solved/Closed
Related:
- Avg multiple cells in multiple sheets - Excel
- Split excel sheet into multiple files - Guide
- Excel multiple lines in one cell - Guide
- Mpc hc multiple instances - Guide
- Google sheets download - Download - Spreadsheets
- How to delete multiple files on mac - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
6 Oct 2011 à 10:16
6 Oct 2011 à 10:16
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
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
