Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summary total from another worksheet?
I am currently trying to setup another worksheet in my workbook to do grand
totals for me. Is it possible - I have a worksheet I do all my job costing on (daily time, materials used, etc.) Now I want to add another worksheet to do like a summary. I enter daily things into my costing record but it is detailed for our reference purposes. Is it possible to set up (I need the formulas) a summary page of a breakdown just on certain items? Example: we might do Prep, every other day and then P&F (Place & Finsh) other days, now I just want a total of just Prep, and P&F. Is there a formula that would lookup the sheet to find a total of specific items? Right now our Job records are sometimes 15 pages long because we do record everyhting in them. I am trying to setup a summary page 1-2 pages for just totals to make it easier when trying to determine certain costing on certain items. Thanks a lot, and hopefully I am not trying to do to much!! tb |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summary total from another worksheet?
Could you send me an example of one of the bigger ones so I can see exactly what you have and how it is laid out. sned to -- intruder9 ------------------------------------------------------------------------ intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107 View this thread: http://www.excelforum.com/showthread...hreadid=502150 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percent of total in Pivot tables | Excel Worksheet Functions | |||
Referencing worksheet names | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Seeking help for total worksheet protection | Excel Discussion (Misc queries) | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |