COUNTIFS problem

[The Jackal]

Hi,

I am trying to count how many times a specific person has scored 100+, 140+ and 180 in multiple dart matches.
Names are in column A and scores are in B3 to S25.
I have a table and tried this =COUNTIFS($A$3:$A$25, Y3, $B$3:$S$25, ">99",$B$3:$S$25,"<140")
Y3 being where the persons name is but i get #VALUE!

Can any of you clever people help a thicko lol

Sorry i cant upload a mini sheet as work comp wont allow.

 

[etaf]

=SUMPRODUCT(($A$3:$A$25=Y3)*($B$3:$S$25=180))

=SUMPRODUCT(($A$3:$A$25=Y3)*($B$3:$S$25>99)*($B$3:$S$25<140))
not will not count if = to 99 or 140
to include those numbers
=SUMPRODUCT(($A$3:$A$25=Y3)*($B$3:$S$25>=99)*($B$3:$S$25<=140))

formula in column Z and AA

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1
2																										99-140	180
3	name1	130	180	20	180	125	180																		name1	2	3
4	name2	25	175	25	175	25	175																		name14	3	1
5	name3	30	170	30	170	30	170
6	name4	35	165	35	165	35	165
7	name5	40	160	40	160	40	160
8	name6	45	155	45	155	45	155
9	name7	50	150	50	150	50	150
10	name8	55	145	55	145	55	145
11	name9	60	140	60	140	60	140
12	name10	65	135	65	135	65	135
13	name11	70	130	70	130	70	130
14	name12	75	125	75	125	75	125
15	name13	80	120	80	120	80	120
16	name14	180	115	85	115	85	115
17	name15	90	110	90	110	90	110
18	name16	95	105	95	105	95	105
19	name17	100	100	100	100	100	100
20	name18	105	95	105	95	105	95
21	name19	110	90	110	90	110	90
22	name20	115	85	115	85	115	85
23	name21	120	80	120	80	120	80
24	name22	125	75	125	75	125	75
25	name23	130	70	130	70	130	70
26
Sheet1

Cell Formulas
Range	Formula
Z3:Z4	Z3	=SUMPRODUCT(($A$3:$A$25=Y3)*($B$3:$S$25>99)*($B$3:$S$25<140))
AA3:AA4	AA3	=SUMPRODUCT(($A$3:$A$25=Y3)*($B$3:$S$25=180))