SUM Functions Exercise

Here you will get some sample files to download for exercising SUM functions.

Function Name: SUMIF

What is SUMIF?

Exercise: A simple data table with different group of items from where you have to sum quantities of each group by using SUMIF.


Function Name: SUMIFS

What is SUMIFS?

Exercise: It is a little more complex table with student name and marks in different subject from where you have to sum the marks of multiple conditions using SUMIFS.