Excel Formulas to Calculate win-loss tie totals in Excel 365!!
Tags: excelformula, excelformulas
Published: 2021-11-12 07:18:31

---
title: Excel Formulas to Calculate win-loss tie totals in Excel 365!!
published: true
date: 2021-11-06 17:26:21 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-win-loss-tie-totals-in-excel-365/
---

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. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Generic Formula

- To calculate Win-Loss tie totals, use the below formula.

```
=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(((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**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/).
- **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.

![](https://geekexcel.com/wp-content/uploads/2021/11/Sample-data-4.png)
_Sample data_

- Then, to calculate win, loss, and tie totals for a team, you have to use the below-given formula in **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(((team1=$G5)*(score1>score2))+((team2=$G5)*(score2>score1)))

```

![](https://geekexcel.com/wp-content/uploads/2021/11/Use-the-Formula-5.png)
_Use the Formula_

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

![](https://geekexcel.com/wp-content/uploads/2021/11/Result.png)
_Result_

- Finally, you have to  **press Ctrl+D key**  to get the results in all other columns.

![](https://geekexcel.com/wp-content/uploads/2021/11/Final-Output-2.png)
_Final Output_

**Check this too:**

- [Excel Formulas for Basic error trapping in Excel Office 365!!](https://geekexcel.com/excel-formulas-for-basic-error-trapping-in-excel-office-365/)
- [Excel Formulas to Calculate All dates in chronological order!!](https://geekexcel.com/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 don’t forget to mention your valuable  **suggestions**  as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Ahead:**

- **[Simple Ways to Add Running Totals in Microsoft Excel 365](https://geekexcel.com/simple-ways-to-add-running-totals-in-microsoft-excel-365/)**
- **[Excel Formula to Calculate the Win-Loss Points ~ Easy Guide!!](https://geekexcel.com/excel-formula-to-calculate-the-win-loss-points-easy-guide/)**
- **[Excel Formulas to Calculate the Average of Numbers!!](https://geekexcel.com/excel-formulas-to-calculate-the-average-of-numbers/)**
- **[Formulas to Calculate Remaining Days ~ A Complete Guide!!](https://geekexcel.com/excel-formula-calculate-remaining-days/)**
- **[How To Calculate the Range contains a specific date in Excel?](https://geekexcel.com/how-to-calculate-the-range-contains-a-specific-date-in-excel/)**