SUM SET
Sum
The SUM function in Excel is used to add up a range of numbers. It calculates the total sum of the specified values.
PRACTICE TASK 1
PRACTICE TASK 2
PRACTICE TASK 3
PRACTICE TASK 4
PRACTICE TASK 5
Sum If
The SUMIF function is used to sum values based on specific criteria or conditions. It allows you to specify a range, a criteria, and a sum range. The function will only sum the values in the sum range that meet the specified criteria.
Sum Ifs
The SUMIFS function is an extension of the SUMIF function that allows you to sum values based on multiple criteria or conditions. It allows you to specify multiple ranges, criteria, and sum range. The function will sum the values in the sum range that meet all the specified criteria.
PRACTICE TASK 1
PRACTICE TASK 2
PRACTICE TASK 3
PRACTICE TASK 4
PRACTICE TASK 5