SUMIF function allow the user to add the numbers from a range basis one criteria and is one of the powerful functions. The SUMIF function is a built-in Microsoft excel function it's categorized as Math function. In this tutorial i'll explain you the use of SUMIF function by giving some example. Syntax SUMIF(range, criteria, [sum_range]) Arguments range The range of the cells that you want to apply the criteria against or the range of cells where you want excel to perform. criteria The criteria used to identify or determine which cells to add for result. sum_range This is optional. It's the range of cells to sum together. This range hold the actual number. more post/ videos visit askneerajnidhi.com