value error

[Jrh]

I am trying to have a total page for jan-dec worksheets. tabs are labeled
jan, feb, mar, etc. I am entering formula =sum(janb4:decb4). How can I add
these without going to each spread sheet and having janb4,febb4,marb4,etc.
Thanks!

 

[Teethless mama]

Type in =Sum(then hold down shift key and select the last tab sheet and cell
reference)

 

[T. Valko]

Try it like this:

=SUM(Janec!B4)

 

[Gord Dibben]

=SUM(Janec!B4)


Gord Dibben MS Excel MVP

 

[Ashish Mathur]

Hi,

You may also want to use the Data > Consolidate function.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com