Array enter =SUM(IF(A1:A7="blah",B1:B7))

Alan Beban

Ivan wrote:

Hi,

I am new here and have a problem hope I can get help in here!

I have two worksheet "W1" and "W2"

In W1 worksheet, it has a column "emp_pin" which is unique. This value is
used in the
Vlookup function to find a numeric value "Paid" in W2 worksheet.
If "W1" and "W2" are one to one relationship, it will work fine. However I
have encountered
the one to many relationship, it means one row in "W1" has many rows in
"W2". I just wonder if I can sum up all the found value "paid" in "W2".

should I still use Vlookup or there is something out there I can use?

Thanks...
Ivna