Adding values from sheets to sheet

Hey!

Did some searching and didn't come up with anything so I'm posting. Ok here's the deal..

Working on my company timesheet using excel and it works great. However I would like to add a value from multiple sheet without having to select or type them in for each sheet (there's about 50 of them). It's the same cell in each sheet I want to add up for a total. I tried to do it manually but excel kept asking to open something but not sure what and it wouldn't let me do more then 3. Any help would be appriciated.

Thanks!

--
Rick

Hi,

To add cell A1 from sheet1 to sheet50 ...

Please Login or Register  to view this content.

Originally Posted by Carim

Hi,

To add cell A1 from sheet1 to sheet50 ...

Please Login or Register  to view this content.

Ok having some problems. Here is what I'm trying to use..

=SUM('Jan 2':'Dec 25'!A43)

All the sheets are labeled "Jan 2", "Jan 9"... all the way through "Dec 25" (every Tuesday for this year). If I've changed the name of the sheet do I need to put ' around the name if there are spaces? I keep getting errors saying the formula does't work.

Thanks!

--
Rick

Hi,

Have a try with following formula ...

Please Login or Register  to view this content.

Glad it fixed your problem ...

Thank you! That did the trick. I had to many ' in there.

Thanks for the feedback ...