Adding values from different tabs

Question

Is there simple formula to add values from different tabs. My formula now looks something like this...=(tab1: cell a2+tab2:cell a2)

Answer 1

Is there simple formula to add values from different tabs. My formula noe looks something like this...=(tab1: cell a2+tab2:cell a2)

Try this formula:

=tab1!A2+tab2!A2

Hope this helps / Lars-Åke

Answer 2

Hi,

If you want to pick up the same cell from each tab, try this

=sum(first_tab:last_tab!A2)

So in your case it would be

=sum(tab1:tab2!A2)

Regards,

Ashish Mathur

Microsoft Excel MVP

www.ashishmathur.com

"DAS Tony G" wrote in message news:a03b1540-07f7-4f6e-81c7-64582f792106...

Is there simple formula to add values from different tabs. My formula now looks something like this...=(tab1: cell a2+tab2:cell a2)

---

Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com

Answer 3

Try to replace the formula

=sum('Cad1'!J60:'Cad18'!J60)

with this formula:

=sum('Cad1':'Cad18'!J60)

or simply, as you don't have any space characters in your sheet names:

=sum(Cad1:Cad18!J60)

Hope this helps / Lars-Åke

Answer 4

I need to do the same operation but I just don't work. I need to calculate the sum of all the J60 cells from tabs Cad1 to Cad18. I can't do it using the formula (in Portuguese) =sum('Cad1'!J60:'Cad18'!J60), but if I type all the tabs number in one gigantic equation it works. This is really frustrating!

Answer 5

Hi,

Please share more details.