Need Help With A Formula Please
 

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 C3= 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=346074

See reply in .Functions

Biff

-----Original 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 C3= 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?
action=getinfo&userid=10969
View this thread:
http://www.excelforum.com/showthread...hreadid=346074

.

Try the following...

=INDEX(Sheet2!C2:C10,MATCH(1,(Sheet2!A2:A10=A2)*(S heet2!B2:B10=B2),0))

...confirmed with CONTROL+SHIFT+ENTER, and where A2 contains your first
criterion and B2 contains your second criterion.

Hope this helps!

EVRPAGING Wrote:
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 C3= 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!!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=346074