frequency above a certain number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A1:A10 are numbers
A2 is another number

A3 is a formula that states: the number of times A1:A10 is above A2

For example:
5 2 3 5 8 9 4 2 0 1 (numbers)
3
5 (# of times numbers are > 3).

thanks...!
 
One way (assuming you meant A1:J1 rather than A1:A10, since otherwise
you'll get a circular reference):

A3: =COUNTIF(A1:J1,">" & A2)
 
thanks, works great.

JE McGimpsey said:
One way (assuming you meant A1:J1 rather than A1:A10, since otherwise
you'll get a circular reference):

A3: =COUNTIF(A1:J1,">" & A2)
Click to expand...
 
Back
Top