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
Answers
-
@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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!