Sum

[Rai]

I have a worksheet with 10 identical tabs. I need to add all of the values of D10 from the 10 tabs to get one total. Is there a way to add all of the same cell from the various tabs other than this
=Tab1!D10+Tab2!D10+Tab3!D10....

 

[Aladin Akyurek]

On 2002-10-31 15:27, Rai wrote:
I have a worksheet with 10 identical tabs. I need to add all of the values of D10 from the 10 tabs to get one total. Is there a way to add all of the same cell from the various tabs other than this
=Tab1!D10+Tab2!D10+Tab3!D10....

=SUM(Tab1:Tab10!D10)

Consult also the Help file about the so-called 3-d formulas.