# 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 to**calculate Win-Loss tie totals** in Excel 365. Lets get into this article!! Get an official version of**MS Excel**from the following link:https://www.microsoft.com/en-in/microsoft-365/excel

## Jump To:

- 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

**SUMPRODUCT**In Excel, this function will help to multiply the corresponding arrays or ranges and returns the sum of the products. Read more on the**SUMPRODUCT 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 to
**create a sample data**in the Excel.

Sample data

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

Use the Formula

- Now, you need to
**Hit the Enter key**to get the result as shown below.

Result

- Finally, you have to
**press Ctrl+D key**to 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 to**calculate Win-Loss tie totals **in Excel 365.Please leave a comment in case of any**queries,**and dont forget to mention your valuable**suggestions**as well. Thank you so much for Visiting Our Site!! Continue learning on**Geek Excel!!**Read more on**Excel Formulas!!**

**Read Ahead:**

**Simple Ways to Add Running Totals in Microsoft Excel 365****Excel Formula to Calculate the Win-Loss Points ~ Easy Guide!!****Excel Formulas to Calculate the Average of Numbers!!****Formulas to Calculate Remaining Days ~ A Complete Guide!!****How To Calculate the Range contains a specific date in Excel?**

#### Rate our Tutorial0 / 5 Total Ratings 0

Your page rank: