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.

"Bernard Liengme" wrote:

Please be a little more specific
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

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