Excel - Average multiple cells in multiple sheets

December 2016



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.

Related :

This document entitled « Excel - Average multiple cells in multiple sheets » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.