Rounding, sums, products, and mathematical operations
SUMIF adds values that match a condition. Give it a range to check, a condition to test, and a range of numbers to sum â it only adds the ones that pass the test.
Adds numbers that meet all of the specified conditions.