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

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.

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

=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.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=491526

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dave Grainger" <Dave wrote in message
...
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.

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

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





"Ron de Bruin" wrote:

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dave Grainger" <Dave wrote in message
...
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.