frequency above a certain number
 

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...!

frequency above a certain number
 

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

A3: =COUNTIF(A1:J1,"" & A2)

In article ,
SteveC wrote:

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...!

frequency above a certain number
 

I'm assuming you mean A1:J1? Try this:

=SUMPRODUCT(--(A1:J1A2))

HTH,
Elkar


"SteveC" wrote:

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...!

frequency above a certain number
 

thanks, works great.

"JE McGimpsey" wrote:

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

A3: =COUNTIF(A1:J1,"" & A2)

In article ,
SteveC wrote:

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...!

frequency above a certain number
 

ah, that tricky sumproduct again. thanks!

"Elkar" wrote:

I'm assuming you mean A1:J1? Try this:

=SUMPRODUCT(--(A1:J1A2))

HTH,
Elkar


"SteveC" wrote:

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...!