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.