Matching Cells in different files to sum.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum column based on single cell match? 1
Function to Use when compare sums another column 3
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Sum Values from different column 1
SUMIF Help 3
SUM - IF - AND 7
matching & combining data from seperate worksheets 2

Back
Top