View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jqchuy66 jqchuy66 is offline
external usenet poster
 
Posts: 4
Default 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