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:
No comments:
Post a Comment