View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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