# Counting frequency of a percentage

1. ## 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?

2. ## Re: Counting frequency of a percentage

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?

3. ## Re: Counting frequency of a percentage

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

4. ## Re: Counting frequency of a percentage

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1