Summary total from another worksheet?

G

Guest

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
 
I

intruder9

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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summary 2
Copy formula from one worksheet to another to get value in 2nd wks 1
Combine data into central worksheet 1
Spreadsheet summary automatically referrences totals of worksheets 2
Autofill summary worksheet 8
Link worksheet totals to a summary worksheet in the same workbook 2
summaries on alternative sheets 6
Excel Summary Page 1

Top