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

✭✭✭✭

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

• ✭✭✭✭✭

@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])

• ✭✭✭✭

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

• ✭✭✭✭✭

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

• ✭✭✭✭

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

• ✭✭✭✭✭

@Connie Cochran Glad it worked out!

• ✭✭✭✭

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%

• ✭✭✭✭✭

@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])))

• ✭✭✭✭

AMAZING! Thank you so much!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!