Number of items meeting a > criterion

M

MikeDH

Is there a way to count the number of cells with numbers greater than X in a
column? I'd appreciate the help.
 
D

David Billigmeier

Mike -
Assume your data is in the range A1:A100 and you want to count how many
numbers are greater than 10, this formula will work:

=COUNTIF(A1:A100,">"&10)
 
M

MikeDH

Excellent. Thank you much sir.

David Billigmeier said:
Mike -
Assume your data is in the range A1:A100 and you want to count how many
numbers are greater than 10, this formula will work:

=COUNTIF(A1:A100,">"&10)
Click to expand...
 
Top