Windows 2000Pro, MSO 2000 Pro

I have two spreadsheets on which I create "Unique" record identifiers by
concatenating two cells using "=A2 & I2" format.

I then have the formula "=SUMIF('102804'!$H:$H,F3,'102804'!$I:$I)" where the
F3 and $H:$H references are to these two columns. The Sumif is returning
completely erroneous data and when I try to re-create the formula using the
wizard, the wizard returns #NUM! as soon as the H:H range formula is added....

The range Column $H:$H and "F" are both formatted text, and I have tried
other concat options and the trim function to try to "marry up" the values....

Any suggestions/explanations would be most appreciated

Thanx