I have two columns which house values and two columns which house numeric numbers. They are residing in different cells addresses. Example are as follows:
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.
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.