Microsoft Excel Help Please

alice's_mum

Am after some help using MS excel if anyone is able.

In work we have set up a table of information that changes every day, (school dinner numbers), this is a workbook with 5 pages 1 for each day of the week. All of the days are set up the same and all the relevant formulas are set up, so it's just a case of entering that days figures.

Now my problem is that at the end of the week currently we print off the 5 sheets and manually add up the inidividal figures for each class and fill in a form and send it to the Council. This is a pain.

What I want to know is can I make a 6th page set out exactly the same as the others but in B3 have the total of the 5 daily B3 cells automatically added up for me.

Hope this makes sense and that someone can help me, it's driving me mad :mad: currently.

Thanks

Liz

woo

Your formula should look something like:

=Sheet2!B3+Sheet1!B3

Wombat

In Cell B3 on Sheet 6 type:

=SUM(Sheet1:Sheet5!B3)

B3 on Sheet 6 will then contain the sum of all the B3 cells from Sheet1 to Sheet5.

alice's_mum

Thanks for the replies, both seem to make sense, have tried yours WOMBAT but this is what I am getting in B3 on page 6

#NAME?

Any ideas why?

Liz

Wombat

alice's_mum wrote: »

Thanks for the replies, both seem to make sense, have tried yours WOMBAT but this is what I am getting in B3 on page 6

#NAME?

Any ideas why?

Liz

Yes - have you given your sheets names? If you have, the names will appear on the tabs along the bottom of your spreadsheet.

My formula assumed the sheets weren't named. Now, if your first sheet is called Fred and your fifth is called Bert, the formula would be

=SUM(Fred:Bert!B3)

Stephen_Leak

Or, taking a wild (but calculated) guess at the worksheet names ...

=SUM(Monday:Friday!B3)

alice's_mum

Wow don't you just love MSE,

Thanks for your replies, yes Stephen Leak sheets are unoriginally called Monday - Friday; you guys have saved me so much time and faf(sp) trying to add this up manually, drives me nuts lots of bits of paper and a calculator when all the answers are in the system especially when the phone rings and you forget where you're up to.


Thank you

pavlovs_dog

just wanted to say thanks to everyone who took the time to reply to this thread, because you've just solved a problem for and saved me from starting a new thread :j