SUM, SUMIF, SUMIFS for Beginners

SUM is a basic Excel function that adds up the values in a range of cells. For example, the formula "=SUM(A1:A5)" will add up the values in cells A1 through A5. This function is useful for quickly finding the total of a column of numbers.

SUMIF is similar to the SUM function, but with the addition of a criteria argument. The SUMIF function adds up the values in a range of cells only if they meet a certain criteria. The syntax for the SUMIF function is: SUMIF(range, criteria, sum_range). For example, the formula "=SUMIF(A1:A5, ">=20", B1:B5)" will add up the values in the range B1:B5 only if the corresponding cells in the range A1:A5 are greater than or equal to 20.

SUMIFS works similarly to the SUMIF function but it allows you to apply multiple criteria. The syntax for the SUMIFS function is: SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...). For example, the formula "=SUMIFS(D1:D5, A1:A5, ">=20", B1:B5, "<=30")" will add up the values in the range D1:D5 only if the corresponding cells in the range A1:A5 are greater than or equal to 20 and the corresponding cells in the range B1:B5 are less than or equal to 30.

In summary, the SUM function adds up the values in a range of cells, SUMIF adds up.