G Guest Aug 10, 2005 #1 Is there a way to count the number of cells with numbers greater than X in a column? I'd appreciate the help.
Is there a way to count the number of cells with numbers greater than X in a column? I'd appreciate the help.
G Guest Aug 10, 2005 #2 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)
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)
G Guest Aug 10, 2005 #3 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...
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...
