Excel: SUMIFS Function
About the video
SUMIFS
The Microsoft Excel SUMIFS function adds all numbers in a range of cells, based on single or multiple criteria. SUMIFS can be used to sum values when corresponding cells meet criteria based on dates, numbers, and text. SUMIFS supports wildcards (*,?) and logical operators (>,<,<>,=) for partial matching. The SUMIFS function sums cells in a range using supplied criteria. In the SUMIF function we can apply one criteria, But in SUMIFS we can apply more than one set of criteria, with more than one ranges. The first range is the range to be summed. The criteria are supplied in pairs (range/criteria) and only the first pair is mandatory. To apply additional criteria, provide an additional range/criteria pair. We can apply up to 127 range/criteria in the function. The SUMIFS function is an inbuilt function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function in Excel. As a worksheet function, the SUMIFS function can be entered as part of a formula in a cell of a worksheet.
Arguments of the Function:
sum_range - The range to be summed.
range1 - The first range to evaulate.
criteria1 - The criteria to use on range1.
range2 - The second range to evaluate.
criteria2 - The criteria to use on range2, and so on...