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?

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?