Adding same cells from different tabs in one summary tab

macabre100

New Member
Joined
Mar 25, 2005
Messages
29
I have seen some posts where they say, use sum(First tab:Last tab!D28) to
sum multiple tabs. However, it's not working for me. It gives #name? error everytime. I have tried different variations but doesn't work.

Do I have to Shift+enter or something like that to get it right?

Please help.

Thanks in advance!
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,057
Office Version
  1. 365
Platform
  1. Windows
Are the worksheets acatually called First tab and Last tab, with the space?

If they are you should enclose the sheet names in single quotes ' or rename them without spaces.
 

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hi,

Click the sum button.

Click the cell to sum in the first tag, then hold down shift and click on the last tag. This should make your formula right.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,455
Messages
5,572,216
Members
412,448
Latest member
ManuW
Top