Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copied info from Excel worksheet, but pasted info won't work in fo KRISTENV Excel Discussion (Misc queries) 3 January 8th 09 03:13 PM
Copy info into empty cells below info, until finds cell with new d Fat Jack Utah Excel Discussion (Misc queries) 3 November 16th 08 08:34 PM
TOTALING ONE COLUMN FROM INFO IN ANOTHER JT Excel Worksheet Functions 2 November 19th 07 04:54 PM
Consolidating Text Info wilma2299 Excel Discussion (Misc queries) 1 August 17th 07 05:50 PM
Link info in one cell to info in several cells in another column (like a database) hansdiddy Excel Discussion (Misc queries) 1 February 22nd 06 02:27 AM


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"