Function Problems

How to Calculate Cribbage Win Percentages in Excel

Adam Davis Sep 30, 2026 869 views

Question details

Calculate weekly win and loss percentages for cribbage games based on whether the initial cut and deal was won or lost.

How to Calculate Cribbage Win Percentages in Excel

Product: Excel
Device & OS: not provided
Scenario: Tracking weekly cribbage statistics to determine how winning or losing the initial deal affects the final game's outcome.
Observed behavior: Needs the correct formula combination to calculate accurate conditional percentages for different deal and game win/loss scenarios.

Before you start

Ensure your weekly cribbage data is organized neatly in columns, such as using Column B for the deal result ('Y' or 'N') and Column C for the game result ('Y' or 'N').

Solution 1Recommended

Calculate Win/Loss Percentages using COUNTIFS and COUNTIF

Use a combination of the COUNTIFS function to count specific outcomes and divide it by the COUNTIF function to calculate the exact percentage for each scenario.

The COUNTIFS function allows you to count rows that meet multiple criteria (e.g., Deal = Won AND Game = Won). By dividing this by a COUNTIF function (which counts the total number of times the Deal was Won), you calculate the conditional win percentage.

Prepare your data layout

Make sure your data is in specific ranges. For this example, assume Column B (rows 3 to 11) contains the deal results ('Y' for won, 'N' for lost) and Column C (rows 3 to 11) contains the game results.

Calculate Deal Won / Game Won

Select a blank cell where you want the result. Type the formula =COUNTIFS(B3:B11,"Y",C3:C11,"Y")/COUNTIF(B3:B11,"Y") and press Enter.

Calculate Deal Lost / Game Lost

In the next cell, calculate the losses by entering the formula =COUNTIFS(B3:B11,"N",C3:C11,"N")/COUNTIF(B3:B11,"N") and pressing Enter.

Calculate Mixed Results

For Deal Lost but Game Won, use =COUNTIFS(B3:B11,"N",C3:C11,"Y")/COUNTIF(B3:B11,"N"). For Deal Won but Game Lost, use =COUNTIFS(B3:B11,"Y",C3:C11,"N")/COUNTIF(B3:B11,"Y").

Apply Percentage Formatting

Highlight the cells containing your new formulas. Go to the 'Home' tab on the top ribbon and click the '%' (Percentage Style) icon to convert the decimal results into readable percentages.

Calculate Win/Loss Percentages using COUNTIFS and COUNTIF

Prevent Formula Errors: If you plan to add more data over time, consider replacing the specific range (like B3:B11) with entire column references (like B:B) or converting your data range into an Excel Table.

Manage Data with WPS Spreadsheet

Easily Calculate and Track Game Statistics in WPS Spreadsheet

WPS Spreadsheet fully supports advanced statistical functions like COUNTIFS and COUNTIF, allowing you to easily track your weekly cribbage scores, analyze win percentages, and format your data with just a few clicks.

1. Open your data file: Launch WPS Spreadsheet and open the file containing your cribbage tracking data.
2. Enter the formula: Click on an empty cell and type the formula =COUNTIFS(B3:B11,"Y",C3:C11,"Y")/COUNTIF(B3:B11,"Y").
3. Calculate the result: Press the Enter key to execute the formula and generate the decimal value.
4. Format as percentage: Select the result cell, navigate to the Home tab, and click the '%' icon to format the decimal as a percentage.

Fully compatible with Microsoft Excel formulas and functionsFree, lightweight, and fast spreadsheet softwareIntuitive UI for effortless data formatting and percentage styling

microsoft office alternative - wps office

Frequently Asked Questions

Why am I getting a #DIV/0! error in my formula?

This error occurs if the denominator evaluates to zero. In this case, if COUNTIF finds no instances of a 'Y' or 'N' in the deal column, it attempts to divide by zero. Ensure your data range is correct and contains the criteria you are searching for.

Can I use 1 and 0 instead of 'Y' and 'N' for wins and losses?

Yes. If you prefer numerical tracking, simply update your formulas to reference 1 and 0 without quotation marks. For example: =COUNTIFS(B3:B11,1,C3:C11,1)/COUNTIF(B3:B11,1).

How do I apply this formula to a growing list of weekly scores?

Instead of using a fixed range like B3:B11, you can reference the entire column by using B:B and C:C in your formulas. Alternatively, you can convert your data range into a Table (Ctrl + T), which will automatically update the ranges in your formulas as you add new rows.

Excel & Data Problems