A B C D

024123 3999 100 -400

039102 3410 200 -100

042101 3050 300 0

I want to sum up column 'C' and 'D' (i.e. value) if the criteria in column 'A' and 'B' (i.e. number) are met.

I think vlookup and hlookup formulas are required here. Can anyone suggest how to go about it?

Please help! Thanks in advance.