Excel Help
 

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

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