Thread: Counting frequency of a percentage

Hi, I'm still new to excel and learning as i go for a job and using excel 2002. Myproblem is if i have a number say .220 in c10 and i enter values in other cells say b5:j5 how can i count how many times those values are at 85% 75% or 65% of the value in c10?

if you are interested in count of numbers in range B5:J5 that have number equal to 85% of the value in C10, try this:
=COUNTIF(B5:J5,85%*C10)
is this what you want?

kinda, my sheet is set up so that say you enter values in cells b3:b5 b7 is =min(b3:b5) and for example k1=.270 i want to compare the result of b7 to k1 and if the result is <=85% of k1 then its one criteria if its <=75% its another and so on

=if(B7/K1<=85%,condition1,if(B7/K1<=75%,condition2,...))