How do I automatically compile totals from 12 worksheets into 1?
 

Each month, we compile seminar information into a line item style excel
worksheet. Line items include type of seminar, number of attendees, number of
actions (blood pressure, body fat, cholesterol, sugar, etc..) taken with each
attendee, location and facilitator. For the current fiscal year, there are 9
separate worksheets. What I want to do is set the worksheets up so that the
total number of attendees and actions will automatically compile into one
worksheet giving me a combined total for the year's activities. I'm sure
this probably sounds more complicated than it is. Any suggestions or help
would be appreciated. Thank You !! PippyKat

How do I automatically compile totals from 12 worksheets into 1?
 

Nel post
*PippyKat* ha scritto:

Each month, we compile seminar information into a line item style
excel worksheet. Line items include type of seminar, number of
attendees, number of actions (blood pressure, body fat, cholesterol,
sugar, etc..) taken with each attendee, location and facilitator.
For the current fiscal year, there are 9 separate worksheets. What I
want to do is set the worksheets up so that the total number of
attendees and actions will automatically compile into one worksheet
giving me a combined total for the year's activities. I'm sure this
probably sounds more complicated than it is. Any suggestions or help
would be appreciated. Thank You !! PippyKat

Maybe you can use a 3D reference to sum up yor worksheets. Check on line
help.


--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

How do I automatically compile totals from 12 worksheets into 1?
 

if they are in the SAME cell on each sheet
=sum(firstsheet:lastsheet!a1)
of course, substitute firstsheet to your actual sheet name, etc

--
Don Guillett
SalesAid Software

"PippyKat" wrote in message
...
Each month, we compile seminar information into a line item style excel
worksheet. Line items include type of seminar, number of attendees, number
of
actions (blood pressure, body fat, cholesterol, sugar, etc..) taken with
each
attendee, location and facilitator. For the current fiscal year, there
are 9
separate worksheets. What I want to do is set the worksheets up so that
the
total number of attendees and actions will automatically compile into one
worksheet giving me a combined total for the year's activities. I'm sure
this probably sounds more complicated than it is. Any suggestions or help
would be appreciated. Thank You !! PippyKat