Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum of mutiple entries on another workbook
Hello,
I have two workbooks, #1 I am not allowed to modify, information is sorted by equipment number and date of entry. I need the sum to show on another workbook, #2, sorted by equipment number, example: workbook #1 equip# owner date amount 555 John 12/1 40.00 12/3 20.00 556 Mark 12/2 35.00 There could be other rows added for future dates and amounts. Workbook #2 equipment total 555 60.00 556 35.00 Any suggestions? -- Thanks, Jesse |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running mutiple excel sheets on mutiple computers | Excel Discussion (Misc queries) | |||
How to share a workbook when entries are chronological? | Excel Discussion (Misc queries) | |||
HOW CAN I PREVENT DUPLICATE ENTRIES WITHIN A WORKBOOK, i.e. job # | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Mutiple Workbook Summary | Excel Worksheet Functions |