Sumif formula has significant role in MS Excel. It is very useful to create the dashboard. Also it can be used with combination of formulas based on the requirement. When you need to sum the values based on the one particular criteria (value), you can use this Sumif formula. This can be used as an array formula, if necessary.