Count syntax for dividing # of "positive numbers" by "total numbers"

There are numbers, both positive and negative digits, and some zeroes, in A2:A22.

The percentage of positive numbers needs to appear in C2.

I was thinking it would be a count function, using something like "Count("positive numbers"(A2:A22)/count(A2:A22)"...?

Thanks for any help you might be able to offer...

Gratefully,
Synthia

Hi Synthia,

Try this:

Please Login or Register  to view this content.

This should work:

=(SUMIF(A:A,">0",A:A)/COUNT(A:A))*100 this gives the sum of the positive numbers divided by the total number of numbers multiplied by 100. Zeros are not being counted as positive though they are counted as a number.

Thanks, but I don't think I explained it well.

Explanation: the numbers represent performance of schools.

I want to see what percent of schools improved.(not concerned at this point with how much of an improvement occurred, just concerned about counting how many schools did not score zero or a negative number, and showing that number as a percentage).

So, if the number is zero, or negative, I don't want to include that in the "improved" percentage.
If there are 100 schools, 10 made "zero" improvement, 40 made negative improvement, and 50 made positive gains (improved) the answer would be 50%.

Thanks for you

Thanks,
Does that eliminate the zero being included with the positive numbers? As I explained later (below) I don't think I explained it well...I need the value to show what percentage of the numbers are not zero or negative numbers... to state the percentage of numbers that are positive numbers...?
Please pardon if yours does that, I am still playing with it on the sheet, I am grateful for your help.
Synthia

I used your suggestions, thank you, to get the formula:

HTML Code: 

THANKS!
Synthia

Use this instead: This counts the positive numbers (numbers that are greater than zero) and divides that by the total number of numbers and gives the result as a percentage. Zeros count as a number and are not counted as positive.

=(COUNTIF(A:A,">0")/COUNT(A:A))*100

THANK YOU SO MUCH! ACCURACY COUNTS! And you ensured it.
Thank you,
Synthia

Hi,
I need to expand it to include other districts, that have 2 line headers in between, so I used:

HTML Code: 

because the numbers are in E6:E21, AND E24:E38, AND E41:E47, that I want to evaluate to see the percentage of those numbers that are positive.

Obviously I don't know what I am doing because I get a value error.
I took off the *100 because I use the percentage format.

More help would be greatly appreciated.
Humbly AND gratefully,
Synthia

I wasn't sure if I was supposed to enter a new thread or just mark it unsolved and hope someone would come back to this..?
Synthia

Formula:

Please Login or Register  to view this content.

This will give you the percentage of POSITIVE numbers (zeros and negatives counted only in the total number of numbers). If there is nothing in the rows separating the ranges of values, then the second half of the formula can be shortened like this:

Formula:

Please Login or Register  to view this content.

This may be shortened even further depending upon what is in column E:

Formula:

Please Login or Register  to view this content.

Thanks, I'll try the first one, there are other numbers in the rows in between...that is where the averages are, actually. of the scores themselves. This is an analysis of the school performance through a different lens.
Thanks, it will just take a couple of minutes. I appreciate you helping again!
Synthia

PERFECT !!! THANKS SO MUCH ...MORE!!!

HTML Code: 

Synthia

I made a typo in the first range in the formulae, which I have corrected.