1 min readfrom 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.

https://preview.redd.it/g4i6goo6zk6h1.png?width=531&format=png&auto=webp&s=77da481926e9119fdd3e5faf891707adac84095c

submitted by /u/flamingweaselz
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#google sheets
#rows.com