How to sum by criteria

You may sum by criteria by using function “sumif“.

Function sumif takes three parameters, the first parameter is the cell range to compare, the second parameter is the value to compare with, currently it must be a cell reference. the third parameter is the cell range to calculate.