Counting a range

[Blink]

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!

 

[Morrigan]

The formula that you are looking for would be COUNTIF(), read it up.

 

[Excel_Geek]

=COUNTIF(A1:A25,">200"), where "A1:A25" is whatever your range is.

 

[Max]

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