Help!!! Match Formula
 

Hello and thank you in advance for your help! I have a Name on a
column. The same name is listed multiple times on another sheet.
However, one of the entries has the word DSL on the colmun next to it
and on the next colum a value. I want to count those values. For
example:

On sheet 1 I have:

Mike on A2

On sheet 2 i have:

A2= Mike B2= Sales c2= 5
A3= Mike B3= DSL B3= 8
A4= Mike B4= Parts C4= 10

I want a formula of sheet1 that will return a value of 8 for Mike by
matching the word Mike and DSL on sheet 2. Please helppppp!!!!

Thanks!!


--
EVRPAGING
------------------------------------------------------------------------
EVRPAGING's Profile: http://www.excelforum.com/member.php...o&userid=10969
View this thread: http://www.excelforum.com/showthread...hreadid=346062

=SUMPRODUCT(--(Sheet2!A2:A100=A2),--(Sheet2!B2:B100="DSL"),Sheet2!C2:C100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"EVRPAGING" wrote in message
...

Hello and thank you in advance for your help! I have a Name on a
column. The same name is listed multiple times on another sheet.
However, one of the entries has the word DSL on the colmun next to it
and on the next colum a value. I want to count those values. For
example:

On sheet 1 I have:

Mike on A2

On sheet 2 i have:

A2= Mike B2= Sales c2= 5
A3= Mike B3= DSL B3= 8
A4= Mike B4= Parts C4 10

I want a formula of sheet1 that will return a value of 8 for Mike by
matching the word Mike and DSL on sheet 2. Please helppppp!!!!

Thanks!!


--
EVRPAGING
------------------------------------------------------------------------
EVRPAGING's Profile:
http://www.excelforum.com/member.php...o&userid=10969
View this thread: http://www.excelforum.com/showthread...hreadid=346062