How can i use data from multiple sheets in a formula?

D

Dave Grainger

im trying to get a sheet for all my sales across 12 months. i want it to be
the 13th sheet and have cumulative data for the year, then use this as a
template for other salespeople. How can i do this? what commands? thanks.
 
G

goober

=SUM(Janurary:December!A1)

Assuming your sheets are labeled by the month this will total all the
data in cells
A1. You have to make shure that sheet13 is not between the 12 monthly
sheets or it will be totaled also.

Hope it helps.
 
R

Ron de Bruin

Hi Dave

If you want to sum certain cells from each worksheet then do this

Put in two dummy sheets(empty sheets) with the name "start" as the first sheet
and one with the name "end" as the last one.

You can use a formula like this then to sum all sheet between start and end
=SUM(start:end!A1)

Another way is to create links to a cell in each sheet
see http://www.rondebruin.nl/summary.htm
 
D

Dannyg10

Thank You! The following information helped me find my answer:

"You can use a formula like this then to sum all sheet between start and end
=SUM(start:end!A1)"

and my answer was -- =sum('Aug 1:Aug31'!c27) and BAM!!! it worked. You
saved my grief:) Thanks
 
Top