Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copied info from Excel worksheet, but pasted info won't work in fo | Excel Discussion (Misc queries) | |||
Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
TOTALING ONE COLUMN FROM INFO IN ANOTHER | Excel Worksheet Functions | |||
Consolidating Text Info | Excel Discussion (Misc queries) | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) |