# How do you add wins and losses in Excel?

Excel allows us to calculate Win-Loss tie totals with SUMPRODUCT functions. This step-by-step tutorial will assist all levels of Excel users to learn how tocalculate Win-Loss tie t

Excel allows us to calculate Win-Loss tie totals with SUMPRODUCT functions. This step-by-step tutorial will assist all levels of Excel users to learn how tocalculate Win-Loss tie totals in Excel 365. Lets get into this article!! Get an official version ofMS Excelfrom the following link:https://www.microsoft.com/en-in/microsoft-365/excel

• Generic Formula
• Syntax Explanation
• Practical Examples
• A Short Summary

## Generic Formula

• To calculate Win-Loss tie totals, use the below formula.=SUMPRODUCT(((team1=\$G5)*(score1>score2))+((team2=\$G5)*(score2>score1)))

## Syntax Explanation

• SUMPRODUCTIn Excel, this function will help to multiply the corresponding arrays or ranges and returns the sum of the products. Read more on theSUMPRODUCT Function.
• Parenthesis () The main purpose of this symbol is to group the elements.
• Plus operator (+) This symbol helps to add the values.

## Practical Examples

• Firstly, you need tocreate a sample datain the Excel.

Sample data

• Then, to calculate win, loss, and tie totals for a team, you have to use the below-given formula informula bar.=SUMPRODUCT(((team1=\$G5)*(score1>score2))+((team2=\$G5)*(score2>score1)))

Use the Formula

• Now, you need toHit the Enter keyto get the result as shown below.

Result

• Finally, you have topress Ctrl+D keyto get the results in all other columns.

Final Output

Check this too:

• Excel Formulas for Basic error trapping in Excel Office 365!!
• Excel Formulas to Calculate All dates in chronological order!!

## A Short Summary

We hope that this short tutorial gives you guidelines on how tocalculate Win-Loss tie totals in Excel 365.Please leave a comment in case of anyqueries,and dont forget to mention your valuablesuggestionsas well. Thank you so much for Visiting Our Site!! Continue learning onGeek Excel!!Read more onExcel Formulas!!