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
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.
- 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](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(((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 don’t 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:
Top comments (0)