How can I combine 4 worksheets into one worksheet that would cont.

[Suzanna]

I am working on a report for my group of 4 schedulers at work. I have created
4 worksheets with totals of calls for specific time periods and days. I need
to combine the 4 worksheets into one "all shedulers" worksheet, without
having to manually add up each scheduler and post in the "all shedulers"
worksheet. Thanks.

 

[GerryK]

As an example: the syntax for a multiple sheet addition of
the same cells is:

=SUM('2003 Jan:2003 Dec'!B14)

This will sum all entries in B14 in the sheets between
2003 Jan and 2003 Dec. Note that punctuation very
carefully.

Adjust for your specifics.

 

[JulieD]

Hi

you might like to have a look at the consolidation feature under data /
consolidate

Cheers
JulieD