Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A function to help sort and calculate
I have a list of data. I need a formula that calculates the % of the cells
that have a number greater than zero in a certain colunm, but that can also calculate the % of cells with numbers less than or equal to zero. I'd also like to take this data and turn it into a graph once it is calculated - can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A function to help sort and calculate
You have a list of numbers (say in A1:A100) that range from (say) -50 to +50
We can count how many are greater than 0 with =COUNTIF(A1:A10,"0") So we can find the percentage with either =COUNTIF(A1:A10,"0")/100, or =COUNTIF(A1:A10,"0")/COUNT(A1:A100). Format the cell as percent We may replace A1:A100 by A:A in all of these For the negative numbers =COUNTIF(A:A,"<=0")/COUNT(A:A) format the cell as percent What data do you want to chart? -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Lost in Excel" wrote in message ... I have a list of data. I need a formula that calculates the % of the cells that have a number greater than zero in a certain colunm, but that can also calculate the % of cells with numbers less than or equal to zero. I'd also like to take this data and turn it into a graph once it is calculated - can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
Calculate total $ based on rows displayed by sort | Excel Worksheet Functions | |||
sort function to sort for bell curve | Excel Discussion (Misc queries) | |||
Complicated sort function with sort and sum | Excel Worksheet Functions | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |