SUMIF function in Excel is a way of summing values that meets a certain criteria. It works sort of like the SUM function but the IF part allows you to sum particluar values such as working out how much money you spent on cheese. I'm sure that you can work other more practicle uses for the SUMIF function. Should you want a more text based step by step insstructions check out the SUMIF guide on our sister site Free Excel Training.
Want to follow along with the SUMIF function in Excel video? Download the SUMIF function exericse file.