Thank you!

I have added your suggestions and understand how they should work however,
(Workbook #1)column B has either the owners name or date of entry and
(Workbook #2) column A now has a zero if the value of workbook #1 was blank.
Hence, the =SUMIF(A:A,O1,M:M) formula in column G does not recognize the
values in column A that = 0?

If I run a filter I only omit those rows which are false...

Any ideas?

Using version 2003

--
Thanks,
Jesse


"Bernard Liengme" wrote:

I will assume that row 1 of Workbook1 has the headers (equip#, owner,etc)
In A1 of Workbook2 enter =[Workbook1.xlsx]Sheet1!A1
Copy this across to column D
Copy A1:D1 down to row 3
Modify D3 to read
=IF([Workbook1.xlsx]Sheet1!A3="",A2,[Workbook1.xlsx]Sheet1!A3)
Copy row 3 down as far as needed - it does not matter if you go down to row
500 and there are only 300 rows used in Workbook1

In F1 enter 555, in F2 enter 556, etc
In G1 enter =SUMIF(A:A,F1,D:D)
Copy down the column to get the required results

a) I am using Excel 2007, so my file extension is XLSX, in earlier versions
it will be XLS
b) If the work book name has spaces in it you need single quotes:
='[Workbook One.xlsx]Sheet1'!A2
c) If the list of Equip# is long, use a filter on Workbook1 (temporarily) to
get a list of unquiet numbers to copy to workbook2 - come back if more info
needed on this topic
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"jqchuy66" wrote in message
...
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

.