Calculate percentage of positive cells in a column

[cableghost]

I would like a formula to calculate the percentage of positive numbers in a given column.

In the attached, the percentage of positive numbers in DATA Sheet, column J is 53% (to be entered in RESULTS Sheet C17. How do I write that in a formula?

Thanks!

[JohnTopley]

in C17

=COUNTIF(Table1[G/L],">0")/COUNT(Table1[G/L])

format cell as %

[cableghost]

Thanks, JT!

For my taste, I formatted cell as Number and multiplied it by 100...

Please Login or Register  to view this content.