SUMIFS Function Step by Step

This Excel tutorial explains how to use the Excel SUMIFS function step-by-step with syntax and examples that works very quickly.

I'll again discuss about this Fumction latter in this blog in detail, for now, please follow this blog

Tutorial Excel Download Link : SUMIFS Sample Tutorial

Description

The Microsoft Excel SUMIFS function adds all numbers in a range of cells, based on a single or multiple criteria.

The SUMIFS function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIFS function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the SUMIFS function in Microsoft Excel is:

SUMIFS( sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, ... criteria_range_n, criteria_n] )

Parameters or Arguments

sum_range

The cells to sum.

criteria_range1

The range of cells that you want to apply criteria1 against.

criteria1

It is used to determine which cells to add. criteria1 is applied against criteria_range1.

criteria_range2, ... criteria_range_n

Optional. It is the range of cells that you want to apply criteria2, ... criteria_n against. There can be up to 127 ranges.

criteria2, ... criteria_n

Optional. It is used to determine which cells to add. criteria2 is applied against criteria_range2, criteria3 is applied against criteria_range3, and so on. There can be up to 127 criteria.

Example (as Worksheet Function)

Let's look at some Excel SUMIFS function examples and explore how to use the SUMIFS function as a worksheet function in Microsoft Excel:

Watch video in this link SUMIFS

or you can watch here