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

OK, I think you need to type it like this:

=SUM('Cad1:Cad18'!J60)

You need the apostrophes as you have sheet names than can be confused with column names.

Hope this helps / Lars-Åke

Answer 4

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 

When I type like =sum(Cad1:Cad18!J60) the program automatically transforms it into =sum(CAD1:'Cad18'!J60) and still gives me no answer. Samefor the last option.