one way:
=COUNTIF(A:A,"=" & AVERAGE(A:A)*0.9) - COUNTIF(A:A,"" &
AVERAGE(A:A)*1.1)
Alternatively:
=SUMPRODUCT(--(A1:A1000=AVERAGE(A1:A1000)*0.9),
--(A1:A1000<=AVERAGE(A1:A1000)*1.1))
In article ,
"Fireman1224" wrote:
I am trying to count the number of values (in a range) that are between two
values (X=Y=Z). The trick is that the X and Z values change when the
values in the range change. I am trying to get the number of actual weights
that are between +10% and -10% of the Mean.
Thanks
|