Need a formula to calculate greater than & show answer as a %

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi!

This will give you the count:

=SUM(COUNTIF(A1:A10,{3,4,5}))

About the percentage .......

Percentage of what? Percentage of the total cells in the range? Percentage
of cells that aren't blank? Percentage of cells that contain numbers?

Biff
 
One try ..

Assuming source numbers in col A,

try in say, B1:
=SUM(COUNTIF(A:A,3),COUNTIF(A:A,4),COUNTIF(A:A,5))/COUNT(A:A)
Format B1 as percentage to taste
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
count the number of rows with entries greater than zero 1
Calculating Future Value 6
Entering an If formula using conditional formatting 1
Greater than a month 2
Position of first number in array greater than a given number 4
Excel Formulas "Not Greater than" 3
Calculating Time? 2

Back
Top