Greater than sum product ?

[blimes]

Column A	Column B	Column C	Column D	Column E	COL F	COL G	COL H	COL I	COL J
TOM	23		18	TOM	PHIL	LANCE	RONNIE	LARRY
PHIL	12
MIKE	2
LARRY	34
RONNIE	43
LANCE	4
TUG	5
EMILY	8
ASHLEY	12

I have a sheet with data like above but many more entries in column J how would i put in a formula to look the names up that are in columns E through I and based on the data in Col A & B tell me how many of the values (col B) for each person in Col E through I ,is greater than the value in Column D.

Thanks for your time.

Adam

 

[JoeMo]

Book1
	A	B	C	D	E	F	G	H	I
1	TOM	23		18	TOM	PHIL	LANCE	RONNIE	LARRY
2	PHIL	12			1	0	0	1	1
3	MIKE	2
4	LARRY	34
5	RONNIE	43
6	LANCE	4
7	TUG	5
8	EMILY	8
9	ASHLEY	12
Sheet2

 

[DanteAmor]

Try this

Book1
	A	B	C	D	E	F	G	H	I	J
1	NAME	VALUE								RESULT
2	TOM	23		18	TOM	PHIL	LANCE	RONNIE	LARRY	3
3	PHIL	12
4	MIKE	2
5	LARRY	34
6	RONNIE	43
7	LANCE	4
8	TUG	5
9	EMILY	8
10	ASHLEY	12
sheet

Cell Formulas
Range	Formula
J2	J2	{=COUNT(IF(--IF(A2:A10=E2:I2,B2:B10)>D2,1))}
Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.

 

[blimes]

Perfect!!! Thank you very much

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.