How to Use SUMIF Function (Formula) In Excel

SUMIF

Use of SUMIF Function (Formula) In Excel

This function in Microsoft Excel adds the cells specified by a given condition or criteria.

Syntax/Formula of SUM IF Function in Excel

The syntax of SUMIF function in Microsoft Excel is below.

=SUMIF(range, criteria, [sum_range])

Example of SUMIF Formula in Excel

In below Example we need Total Payment Amount of ATK PVT LTD

So in this case we use SUMIF function.

Step1: First create below table in your excel starting from cell range A1 to D11.

Step2: Type formula =SUMIF(B1:B11,"ATK PVT LTD",C1:C11) in cell A14 and press enter.

in Above formula B1:B11 is range (Company Name List).

"ATK PVT LTD" Is our criteria.

C1:C11 Is sum_range.

SUMIF