how to do % of cells with data
Hi Matthew
Try
=COUNTIF(C1:C8,"=x")/COUNTIF(A1:A8,"=x")
Format the cell as Percentage.
Regards
Roger Govier
matthewst wrote:
My sheet looks like this:
_ABCDEF____
1x_x_______
2x_x_______
3x_x_______
4x_x_______
5x_________
6x_________
7x_________
8x_________
I want to know the % of cells in column C that have data in them, and
display this % in E1. Column A tells us we have 8 rows, so E1 then
would display 50%.
|