{"id":8245,"date":"2018-08-09T08:06:05","date_gmt":"2018-08-09T08:06:05","guid":{"rendered":"http:\/\/www.nurturetechacademy.in\/?p=8245"},"modified":"2018-08-11T06:12:12","modified_gmt":"2018-08-11T06:12:12","slug":"use-sum-function-excel","status":"publish","type":"post","link":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/use-sum-function-excel\/","title":{"rendered":"Use of SUM IF function in Excel"},"content":{"rendered":"

Use of SUMIF function in Excel-<\/u><\/strong><\/p>\n

SUMIF <\/strong>helps to sum up values only once it matches certain criteria. It can be used to add numbers based on criteria\u2019s like Text, Number and Dates, also can use with logical operators (=,<>,>,< ) and wildcards (*asterisk, ? Question mark).<\/p>\n

\"1\"<\/p>\n

 <\/p>\n

As you noticed in the screenshot above, we need the total amount for Nikky<\/strong> (Sales Person), in second row we need the total values after 31st<\/sup> July 2018<\/strong> and in the third row we need to get the total amount of those zone\u2019s which are having Alphabet \u201cE\u201d in their names.<\/p>\n

Syntax of SUMIF-<\/strong><\/p>\n

Start typing the function with equal \u201c=\u201d symbol and type SUMIF then press CTRL+A to get function arguments dialogue box. see below<\/p>\n

\"2\"<\/p>\n

 <\/p>\n

Range-<\/strong> The range of cells from which you want to apply your criteria.<\/p>\n

Criteria-<\/strong>\u00a0 The criteria regulate which cells you want to add.<\/p>\n

Sum_range-<\/strong>\u00a0 The cells range which you want to Add [Optional]. If you omit the sum range, Sumif provides the total of range itself.<\/p>\n

Let\u2019s take an example and understand how SUMIF works-<\/strong><\/p>\n

\"3\"<\/p>\n

 <\/p>\n

We have a Sales report and we need to calculate total sales of one sales person \u201cNIkky\u201d.<\/p>\n

\"4\"<\/p>\n

 <\/p>\n

Syntax and arguments, we already demonstrate above.<\/em><\/p>\n

Note:-<\/strong>If your \u201cCriteria\u201d contains text then it needs to be entered using double quotation mark (\u201c) around it.<\/p>\n

Wildcards with SUMIF-<\/strong><\/p>\n

\"5\"<\/p>\n

 <\/p>\n

In this table we need to get total amount of Zone which should start with Alphabet \u201cE\u201d.<\/p>\n

\"6\"<\/p>\n

 <\/p>\n

There are two types of wildcards available in Excel-<\/p>\n