Help with a function/formula for cribbage

Question

I'm trying to calculate the percentage of winning and losing games of cribbage based on winning or losing the initial cut to see who goes first. I've been playing with a COUNTIF function but obviously I'm not getting it right. The considerations are 1) did I win or lose the deal then 2) did I win or lose the game. Then I want to calculate the percentages associated with the results.

We play 9 games per week and I would like to add to the SS weekly and calculate the odds over a long period of time. I have attached 1 week of data.

Answer 1

You’re welcome!

Hope it worked

Answer 2

I swear I had that formula but received an error. Close but not quite I guess.

Thank you, I will try these!

Denis

Answer 3

Hello,

For the percentage of games won when the deal is won: =COUNTIFS(B3:B11, "Y", C3:C11, "Y") / COUNTIF(B3:B11, "Y") For the percentage of games lost when the deal is lost: =COUNTIFS(B3:B11, "N", C3:C11, "N") / COUNTIF(B3:B11, "N") For the percentage of games won when the deal is lost: =COUNTIFS(B3:B11, "N", C3:C11, "Y") / COUNTIF(B3:B11, "N") For the percentage of games lost when the deal is won: =COUNTIFS(B3:B11, "Y", C3:C11, "N") / COUNTIF(B3:B11, "Y") Place each formula in the cell where "function?" is written, corresponding to the result you want to calculate. This will give you the percentages based on the outcomes of the deal and the game. Remember to format the cells with these formulas as percentages in your spreadsheet application.

Hope this helps!

Warm Regards, Ozi