Automatic Sum across all tabs

[1Stacy]

Hi Everyone,
I'm not even sure if this is possible, but I figured if it was someone here would know.

I have a front page summary of a workbook.
All of the tabs (in the real workbook there are about 20 tabs), are set up in the same way.

I was wondering if there is a way to automatically sum all of the same numbered cells on each tab.

Add new Switches Adding all B6
Recycle switches Adding all D6
Add Ports Adding all D15
Add UPS If entry in D16 add 1
Add PDU If entry in D18 add 1
Remediate Cooling Issue If entry in D21 add 1
Add Rack(s) Add all D25
Reconstruct Comm Closet Add all D26

Is there a way to do this without adding cell B6 on each of the tabs - I have several workbooks to do this for and some have upwards of 35 tabs.

[JieJenn]

I am giving you one example and I think you can figure out the rest. To sum B6 across all worksheet name starts with a L this is the formula that I would use =SUM('L*'!B6)

[MrShorty]

See here a discussion on using 3D references in formulas: https://support.office.com/en-us/art...es_in_formulas
Note that not all functions support 3D references, but the SUM() function is one that does.

[JeteMc]

Counta will also support 3D references (drilling). In the cases where you just want to count the number of cells where there was a value, as in "Add UPS If entry in D16 add 1", you could use:

Please Login or Register  to view this content.

Let me know if you have any questions.