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.

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

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

"dnice66" wrote in message
...
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.

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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dnice66" wrote:
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.