Compare, Match & Sum HELP

  • Thread starter Thread starter Fredw
  • Start date Start date
F

Fredw

I am looking for a formula that will compare 3 or 4 columns in 2 different
excel workbooks and if a match is found, sum a different column for the
corresponding matched rows. Approximately 1500 rows would be checked.

I was able to do it using a combination of; "sum", "if" and "and" in my
formula, but the formula has to be repeated for each row and will only allow
the formula to be long enough to do 4 rows before the formula gets to be too
long for the cell.
 
will only allow the formula to be long enough ..

Just a thought .. you could try simplifying the task by having everything
done in one book rather than across books (eg: copy/move the relevant sheets
from one book into the other, then formulate it there), and by using very
short, simple sheetnames for the sheets involved (rename as eg: a,b,c ... or
1,2,3). Both steps would immediately cut down formulas' length drastically.
 
While shortening the sheetnames would indeed decrease the invidual parts of
the formula, but at 1,500 lines, the formula will still to be too long for an
single cell. I am thinking "vlookup", "sumif" or something that would
encompass a "range" is the direction that I need to head.

Thank-you for the reply,
 
Back
Top