countif

[3LeggedDog]

I've found that I'm a lot more rusty than I expected, so maybe I'm just missing something simple here. I have this sheet of baseball statistics. I want to rank (but not sort) players by their ERA (column W). I figured that I could do this by using CountIf; knowing the number of players in the range, and then counting the number of players with an ERA higher than the current one, should give me a ranking.

I was planning on using
=countif(W2:W11,">= indirect("W"&row())")

but that doesn't seem to work. Any thoughts? Thanks

pitching 1871-2005.xls
	W	X	Y	Z	AA	AB	AC	AD	AE
1	ERA	IBB	WP	HBP	BK	BFP	GF	IPouts	Ranking
2	1.27	5	1	5	0	427	61	319
3	8.38	0	1	0	0	48	1	29
4	2.40	2	1	0	0	174	11	124
5	4.30	8	1	3	0	373	40	264
6	2.98	7	4	1	1	232	23	163
7	3.16	5	5	4	1	312	10	222
8	3.90	4	7	3	2	291	17	194
9	4.15	3	0	0	0	62	1	39
10	1.70	4	5	4	0	279	26	206
11	4.10	2	5	5	1	331	0	224
tmp

 

[Aladin Akyurek]

=RANK(W2,$W$2:W$11)