0
Thanks

A few words of thanks would be greatly appreciated.

Excel - Average multiple cells in multiple sheets



Issue


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?

Solution


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

Thanks to TrowaD for this tip.
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Related

This document, titled « Excel - Average multiple cells in multiple sheets », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

0 Comments