Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! 401k match formula | New Users to Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Offset & Match Formula Shows Duplicates | Excel Worksheet Functions | |||
how to build a formula to match numbers in 2 columns with the equ. | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions |