Thanks Roger but i think ive confused the issue and just wanted to check
before i mess up big time!

my summary sheet is in columns of day 1, day 2, day 3 etc, and corresponds
with the worksheets day 1, day 2, day 3 etc. The columns are just totals of
certain bits of information from the daily sheets.

eg on the daily sheets would be list of visitors names to the showroom,
models they looked at, demos done, quotes etc showing as a breakdown per
visitor.

The summary page is just of total of visitors, models, demos etc.

Will you solution still be ok?

thanks lots
Carol

"Roger Govier" wrote:

Hi

For your summary, you can use
=SUM(1:31!B2)
to add all of the values from cell B2 on sheet 1 through sheet 31.
This assumes that the sheets are named 1, 2, 3 etc.
If they are called Day 1, Day 2 etc then it would be
=SUM('Day 1:Day 2'!B2)
Note the single quotes, which are necessary if there are any spaces in
the sheet names
--
Regards

Roger Govier


"englishrose4719" wrote in
message ...
Ive got 31 x daily figures spreadsheets which i need to total up
(daily) on a
Month End sheet. Is there a quick way to copy the formulas across
instead of
having to rewrite it on all 31 worksheets? Ive not had much
experience with
Excel but have got the formulas transferring from the Day 1 sheet to
the
Month End sheet ok. Help in a non technical manner would be great
please?!
thanks