Learn the Sumif formula of MS Excel in the easiest way. The Excel Guru teaches how to calculate the the Sum of a range based on a specific criteria using the the Sumif formula .
The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 5000).
Parameters or Arguments of Sumif Formula
The range of cells that you want to apply the criteria against.
The criteria used to determine which cells to…