Adding columns from different tabs

[goinghd]

I have a workbook with 4 tabs, in the first 3 tabs the values in "B1" I need to total in the fourth tabs "B1" Hoe do I do that?

[Fotis1991]

Hi

try this in Sheet4!b1

=SUM(Sheet1:Sheet3!B1)

[davesexcel]

One of these methods should work

=SUM(Sheet1:Sheet3!A1) 

Please Login or Register  to view this content.

[goinghd]

I did what you said, now In tab4 "b1" it says #Name?

[goinghd]

I tried two different things
=Sum(Sheet1:Sheet3!b1) now in tab4 b1 it says #Name?
=Sheet1!A1+Sheet2!A1+Sheet3!A1 now in tab 4 b1 it says #Ref!

Any ideas?

[Fotis1991]

Take a look to the sample.

[goinghd]

Thanks, I got it to work by re-naming my tabs?? Thanks!