countif

3LeggedDog

Board Regular
Joined
Feb 11, 2006
Messages
149
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
WXYZAAABACADAE
1ERAIBBWPHBPBKBFPGFIPoutsRanking
21.27515042761319
38.38010048129
42.40210017411124
54.30813037340264
62.98741123223163
73.16554131210222
83.90473229117194
94.15300062139
101.70454027926206
114.1025513310224
tmp
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,141,626
Messages
5,707,483
Members
421,510
Latest member
haroonstr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top