A function to help sort and calculate

L

Lost in Excel

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?
 
B

Bernard Liengme

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?
 

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

Excel Average dates help 0
excel formula needed 3
Need a Function 7
Help with a COUNTIF, Please 13
Multiple condition data validation 3
Can multiple criteria be used for IF formulas? 4
Formula which is greater tahn or equal to zero 2
Calculate month & year in between two dates 2

Top