Excel Help

F

Fireman1224

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
 
J

JE McGimpsey

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))
 
Top