Re: use Vlookup for sum all found value?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Alan Beban (unavailable_at_no.com)
Date: 07/05/04 

Date: Mon, 05 Jul 2004 08:50:12 -0700

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 work*** "W1" and "W2"
>
> In W1 work***, 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 work***.
> 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
>
>

Quantcast