Counting a range

Blink · Aug 25, 2005

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 · Aug 25, 2005

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

Excel_Geek · Aug 25, 2005

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

Max · Aug 25, 2005

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

Counting a range

Blink

Morrigan

Excel_Geek

Max