consolidating or totaling info
 

previously i had asked about a 12 page (monthly) workbook where i input daily
info
and each page has totals. i would like to total most or part of each month
on a
final recap page. the info i was given should do it, but i am not sure of
the steps
involved as i have limited working knowledge.
thanks

consolidating or totaling info
 

Hi,

If you have a total on each page at a specific location, say A100, then you
can write a formula such as:

=SUM(Sheet2:Sheet13!A100)

or if they are not in the same cells you could use something of the form

=SUM(Sheet2!A99,Sheet3!A87,Sheet4!100,...)

Without more info we can't tell you much more.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"M.GONZALEZ" wrote:

previously i had asked about a 12 page (monthly) workbook where i input daily
info
and each page has totals. i would like to total most or part of each month
on a
final recap page. the info i was given should do it, but i am not sure of
the steps
involved as i have limited working knowledge.
thanks

consolidating or totaling info
 

Hi,

A good starting point could be reading up on Data Consolidate in the Help
menu. It is very easy to use and is menu driven

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"M.GONZALEZ" wrote in message
...
previously i had asked about a 12 page (monthly) workbook where i input
daily
info
and each page has totals. i would like to total most or part of each month
on a
final recap page. the info i was given should do it, but i am not sure of
the steps
involved as i have limited working knowledge.
thanks