How to use SUMIFS Function (Formula) In Excel

SUMIFS

Use of SUMIFS Function (Formula) In Excel

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

Syntax/Formula of SUMIFS Function

The syntax of SUMIFS function in Microsoft Excel is below.

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

Example of SUMIFS Function in Excel

In below Example we need Total Unpaid amount of HYX PVT LTD.

So in this case we use SUMIFS function.

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

Step2: Type formula =SUMIFS(C1:C11,B1:B11,"HYX PVT LTD",D1:D11,"Unpaid") in cell A14 and press enter.

In Above formula C1:C11 is Sum range (Payment Amount).

B1:B11 is criteria_range1 (Company Name List).

"HYX PVT LTD" Is our criteria1.

D1:D11 is criteria_range2 (Status).

"Unpaid" Is our criteria2.

SUMIFS FUNCTION