|
|
|
|
#1
02-21-2017, 12:24 AM
|
||||
|
||||
Why not :
group the tabs (click the first tab then the last while holding the Shift key) enter the COUNTIF function in an occupied cell on the first sheet ( it will copy automatically to all sheets in the group) Now on you master sheet use the SUM function with a 3D reference to obtain the final result You can ungroup whenever needed
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 COUNTIF(INDIRECT doesn't autoupdate cell references when I add a column somewhere else in my sheet
|
Helix2 | Excel | 7 | 10-25-2016 03:20 AM |
|
Multiple browser windows or tabs
|
Buckeyegator | Outlook | 1 | 11-28-2011 08:53 PM |
| Multiple browser windows or tabs | Buckeyegator | Office | 0 | 11-27-2011 05:06 PM |
| Multiple IExplorer Tabs open with link | robertkjr3d | Outlook | 2 | 07-26-2010 11:30 AM |
| Create Multiple Tabs from Template | TeePee | Excel | 0 | 04-30-2009 11:54 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode