Here, we will learn how to use the Excel math functions: SUM, SUMIF and SUMIFS.
SUM function
The Excel SUM function returns the sum of numbers supplied. The function can be found in all the versions of Excel. SUM takes the arguments like this: (number1, [number2], [number3],…), of which number1 is required, and thereafter subsequent optional arguments.
SUMIF function
The Excel SUMIF function returns the sum of cells that meet a single condition. The function can be found in all the versions of Excel. SUMIF takes the arguments like this: (range, criteria, [sum_range]), of which range and criteria are required and sum_range is optional.
SUMIFS function
The Excel SUMIFS function returns the sum of cells that meet multiple conditions. The function can be found in all the versions of Excel. SUMIFS takes the arguments like this: (sum_range, range1, criteria1, [range2], [criteria2],...), of which sum_range and a pair of range and criteria are required and thereafter subsequent pair of optional arguments of range and criteria.
You have successfully learnt how to use the Excel math functions: SUM, SUMIF and SUMIFS.
