View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dnice66
 
Posts: n/a
Default Need a formula to calculate greater than & show answer as a %

I need to calculate the number of times (within a column of numbers ranging
between 0-5) that 3-5 are used. There are also cells within this colum that
are blank. Then I need to caluculate the total of times numbers 3-5 are
shown; however, answer must be in a percentage.

I am using a spreadsheet that is always changing daily. Please help.