Compare, Match & Sum HELP

[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.

 

[Max]

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.

 

[Fredw]

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,

 

[Max]

Try posting your top cell formula ..