Formula Errors

How to Count Positive and Negative Win-Loss Values in Excel

Olivia Miller Oct 19, 2026 869 views

Question details

The user wants to count positive numbers (representing wins) and negative numbers (representing losses) within a data column, and display the result together in a single cell as a formatted win-loss record.

How to Count Positive and Negative Win-Loss Values in Excel

Product: Excel
Device & OS: not provided
Scenario: Tracking and summarizing performance records where a dataset contains positive and negative numeric values that need to be aggregated into a standard win-loss format.
Observed behavior: Requires a specific formula configuration that counts multiple conditions simultaneously and combines the outputs into a text string separated by a hyphen.

Before you start

Ensure that the cells containing your positive and negative values are formatted as numbers rather than text. If these numbers are generated by another formula, verify that the calculation outputs standard numerical values.

Solution 1Recommended

Use the COUNTIF Function with the Ampersand Operator

This is the most direct and recommended method to count specific conditions and concatenate the results into a single formatted string.

By utilizing two separate COUNTIF functions and joining them together with an ampersand (&), you can easily count values greater than zero and less than zero, formatting them together.

Select the destination cell

Click on the empty cell where you want your final win-loss record to be displayed.

Enter the combination formula

Type the formula: =COUNTIF(A3:A16, ">0") & "-" & COUNTIF(A3:A16, "<0"). Adjust the range A3:A16 to match the actual cells containing your data.

Apply the calculation

Press Enter. The cell will calculate and display the total number of positive values followed by a hyphen and the total number of negative values (e.g., 10-4).

Use the COUNTIF Function with the Ampersand Operator

Handling Zero Values: This exact formula counts values strictly greater than zero and less than zero. Any exact zero values in your data range will be ignored and not counted as either wins or losses.

Solution 2

Use the CONCATENATE Function with COUNTIF

An alternative approach using the standard CONCATENATE function to achieve the same win-loss formatting without using the ampersand operator.

Efficient Data Management

Easily Calculate Win-Loss Records with WPS Spreadsheet

You can quickly apply complex COUNTIF formulas to track your wins and losses using WPS Spreadsheet. It features an intuitive interface and is fully compatible with all standard Excel formulas, making your data analysis seamless.

1. Open your dataset: Launch WPS Spreadsheet and open the file containing your positive and negative numbers.
2. Select the target cell: Click on the cell where you want the win-loss record to appear.
3. Input the formula: Type =COUNTIF(A3:A16, ">0") & "-" & COUNTIF(A3:A16, "<0") into the formula bar.
4. View the result: Press Enter to instantly display your formatted win-loss string.

100% compatible with Microsoft Excel formulas and file formats (.xlsx)Lightweight software that processes complex calculations quicklyUser-friendly interface perfect for both beginners and advanced usersFree to use basic features for everyday data management and reporting

Frequently Asked Questions

Why does my COUNTIF formula return a result like 16-0 even though I have negative numbers?

This typically happens if your data is formatted as text rather than numbers, or if the numbers are generated by a preceding calculation that converts the output to text. Check your cell formatting and ensure the evaluated column outputs raw numerical values.

How can I include zeros (ties) in my win-loss record?

You can extend the formula to add a third COUNTIF specifically for zeros. Use =COUNTIF(A3:A16,">0") & "-" & COUNTIF(A3:A16,"<0") & "-" & COUNTIF(A3:A16,"=0") to format the result accurately as Wins-Losses-Ties.

Can I apply conditional formatting to color the win-loss text string?

Because the combined formula results in a text string (e.g., '10-4'), standard numeric conditional formatting options like greater than or less than won't work. However, you can use the 'Text that Contains' conditional formatting rule to highlight the cell if it matches a specific text pattern.

Excel & Data Problems