Adding same cells from different tabs in one summary tab

[macabre100]

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!

 

[Norie]

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]

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.

 

[macabre100]

Thanks a ton, guys! It worked.