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