View Single Post
  #4   Report Post  
Max
 
Posts: n/a
Default

Assuming numbers are in col A,
try in say, B1: =COUNTIF(A:A,"200")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Blink" wrote in message
oups.com...
Hi,
I am having problems using a count formula. I have a list of numbers
and I want to count how many numbers are greater than 200. I'm not
sure which count formula to use and how to use it. Please help!
Thanks!