ADD SAME CELL IN DIFFERNT TABS

[cdf]

HOW DO I ADD SAME CELL IN DIFFERNT TABS IN A WORKSHEET?

 

[Chip Pearson]

Try something like

='Sheet1'!A1+'Sheet2'!A1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[igorek]

=sum('sheet1:sheet5'!A1)

 

[Frank Kabel]

Hi
- first select the required tabs (grouping them)
- after this insert your value