A function to help sort and calculate

  • Thread starter Thread starter Lost in Excel
  • Start date Start date
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?
 
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?
 
Back
Top