count function

D

Dennis

I am trying to create a cell with the function that will
count how many cells in a column have a value that is
greater than a certain value, any help?

thanks

Dennis
 
S

Steve Garman

Everything in column A if value > 6
=COUNTIF(A:A,">6")

Everything in column A if value > the value in B2
=COUNTIF(A:A,">"&B2)
 
Top