| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to show zero if reference cell is zero? tricky! | Excel Worksheet Functions | |||
| Excel: Allow combination of formula answer and text in one cell | Excel Worksheet Functions | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How do I calculate a formula with a not-to-exceed answer? | Excel Discussion (Misc queries) | |||
Linear Mode
