COMPARE VALUEW IN 2 COLOUMNS and return the sum of the corresponding in Third Coloumn

[devlin]

COMPARE VALUEW IN 2 COLOUMNS and return the sum of the corresponding in Third Coloumn

EMP ID to be checked in 1st coloumn in worksheet 1. ALL IDs in coloumn in worksheet2. SUM of Coloumns corresponding to query in worksheet 2.

 

[Aladin Akyurek]

COMPARE VALUEW IN 2 COLOUMNS and return the sum of the corresponding in Third Coloumn

EMP ID to be checked in 1st coloumn in worksheet 1. ALL IDs in coloumn in worksheet2. SUM of Coloumns corresponding to query in worksheet 2.

Looks like you want...

Sheet2:

=SUMPRODUCT(SUMIF($A$2:$A$400,Sheet1!$A$2:$A$20,$B$2:$B$400))

This formulas matches column A on Sheet2 with values in A2:A20 on Sheet1 and sums the associated numbers from B2:B400.

Adjust to suit.

 

[devlin]

Sure let me try that out thanks for the quick response.

 

[devlin]

Hi the range provided is diff for columns A and B.
Let me try to rephrase my query and add a bit more to it.
Compare values in Column A in Worksheet 1 with values in worksheet 2, and then for a certain condition in column C of worksheet say=703000. Sum all corresponding values in column D,
Thanks,,

 

[Aladin Akyurek]

Hi the range provided is diff for columns A and B.
Let me try to rephrase my query and add a bit more to it.
Compare values in Column A in Worksheet 1 with values in worksheet 2, and then for a certain condition in column C of worksheet say=703000. Sum all corresponding values in column D,
Thanks,,

Still not fully specified...

What is the range in column A on Sheet1?

Values in worksheet 2: In which range?

What is the range in column C and on which worksheet for which 703000 must hold?

Column D on which sheet?