+ Reply to Thread
Results 1 to 4 of 4

Counting frequency of a percentage

  1. #1
    Registered User
    Join Date
    02-25-2009
    Location
    frankfort,ky
    MS-Off Ver
    Excel 2002
    Posts
    2

    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. #2
    Registered User
    Join Date
    01-30-2009
    Location
    USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    67

    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. #3
    Registered User
    Join Date
    02-25-2009
    Location
    frankfort,ky
    MS-Off Ver
    Excel 2002
    Posts
    2

    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. #4
    Registered User
    Join Date
    01-30-2009
    Location
    USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    67

    Re: Counting frequency of a percentage

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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