View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
paul
 
Posts: n/a
Default Formula Question

=COUNTIF(E1:E250,"200")
--
paul
remove nospam for email addy!



"Chris" wrote:

Hi, here's my situation. This is going to sound stupid but...

I'm setting up a spreadsheet to keep track of all my bowling scores
throughout the year. OK, so if I have a list of scores, say 250, how do I set
up a formula to count the number of 200+ games within that list of 250. The
number of 200+ games bowled should show up, period. So if I bowled 57 200+
games than 57 should show up.

Thanks!