Trying to find the percentage of time that a word appears in a column.

Connie Cochran

I have a column with Red, Green and Yellow but I want to find the percentage of times the word Red is used.

I tried =COUNTIF([All screeners present at event]:[All screeners present at event], "Red"), /COUNT([All screeners present at event]:[All screeners present at event])) but I'm getting an error

ShelbyWarren

@Connie Cochran Try this:

=(COUNTIF([All screeners present at event]:[All screeners present at event], "Red")) / COUNT([All screeners present at event]:[All screeners present at event])

Connie Cochran

Thank you but I am still getting an error saying #UNPARSEBLE

ShelbyWarren

@Connie Cochran Strange. It's working for me in the example below. Can you share a screenshot of the sheet/columns?

Connie Cochran

If figured it out, I had space that I shouldn't have. Thank you so much for your help!!!!

ShelbyWarren

@Connie Cochran Glad it worked out!

Connie Cochran

What if instead of the word red I just wanted to find the percentage of all cells that had a value in it some cells are blank. Like there are 50 cells but only 5 of them have anything in it =10%

ShelbyWarren

@Connie Cochran Does the primary column of the sheet always have a value in it? Or is there another column that always has a value in it? If so, use this formula but replace the "Primary Column" with a column that always will have a value:

=(COUNT([All screeners present at event]:[All screeners present at event]) / (COUNT([Primary Column]:[Primary Column])))

Connie Cochran

AMAZING! Thank you so much!