count function

  • Thread starter Thread starter Dennis
  • Start date Start date
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
 
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)
 
Back
Top