Excel - Average multiple cells in multiple sheets

April 2018


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?


Here is your formula:

Type this formula in your designated cell in Sheet 5

Thanks to TrowaD for this tip.
Published by aakai1056. Latest update on October 7, 2011 at 07:18 AM by aakai1056.
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 (https://ccm.net/).
Excel - A Macro to insert data in specific cells
Excel - Creation of dropdown from dynamic list in VBA