How do I total counts on multiple tabs in a workbook in Excel 2010?
Posted on 2014-09-25
I have a workbook with 60+ tabs. Each tab has been subtotaled to Count account numbers in column A. In a master tab, I would like to total all the counts into one cell. Is there a formula that can do this without using Consolidate and creating 60+ ranges? The counts in the various sheets can range from 1 to several thousand so the Grand Counts are in different rows.
I've tried Sumif using tab 2:tab 60 but that didn't work.
Suggestions would be greatly appreciated.