To sum cells based on multiple criteria we can use SUMIF or SUMIFS function depending on the condition. If you want to learn SUMIFS function then this article is especially for you. In this article we will focus on how to sum values meeting matches values from multiple rows of data.
Question): I have a data comprising of Soccer Goals for each week; I want to calculate the goals by a particular team. Which formula I can use?
Following is the snapshot of data we have:
To calculate a team’s highest goal in specific week we will use SUMIFS function.
In this way we can SUMIF & SUMIFS function to meet multiple conditions in various rows of data.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.