•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How can I find the percentage of how often two distinct drop down options are selected? (Google Sheets)
I'm currently trying to build a winrate tracker for a card game, and whilst I know that I can use COUNTIF to calculate the percentage for a Win/Loss column, I can't figure out how to do this for two distinct drop downs. As you can see from my image, I want to calculate a win/loss percentage against each of the options in the 'Opponent's Faction' column. In effect, I want a way to count the number of rows that contain both Criminal and Win, and then find the number for Criminal and Loss, and then display those values as a percentage.
Thanks for your help.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#google sheets
#Excel alternatives
#Google Sheets
#COUNTIF
#Winrate
#Tracker
#Dropdown
#Percentage
#Win/Loss
#Opponent's Faction
#Criminal
#Card Game
#Data Analysis
#Rows
#Column