Matching Cells in different files to sum.

1

1gr8tigerfan

How can I make an inquiry between 2 files where I want to search for matches
in a column between the worksheets and then sum the appropriate data.
 
1

1gr8tigerfan

Column A in File #1 contains serial numbers. Column C in File #2 contains
serial numbers and has a Column AC showing costs. How do I arrange a search
between the 2 files so that when a serial number in File #1 matchs a serial
number in File #2, the associated costs in File #2 is summed by the serial
number.
 
Top