SUM, SUMIF, SUMIFS, SUMPRODUCT

1. Sum Function
The SUM function adds up a range of numbers, cell references, or results from other functions.

Syntax:

=SUM(number1, [number2], ...)

number1, number2, ... → Can be individual numbers, cell references, or ranges.

2. SUMIF Function
The SUMIF function adds up cells that meet a single condition.

Syntax:

=SUMIF(range, criteria, [sum_range])

range: The range of cells to evaluate (where condition is checked).
criteria: The condition.
sum_range: (Optional) The actual range to sum if different from the condition range.

3. SUMIFS Function
The SUMIFS function adds up cells that meet multiple conditions.

Syntax:

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

sum_range: The range to sum.
criteria_range1, criteria_range2: Ranges to check for conditions.
criteria1, criteria2: Conditions to apply.

4. SUMPRODUCT Function
The SUMPRODUCT function multiplies corresponding elements in arrays (ranges) and then sums the results.
It can also handle conditional summations by combining with logic.

Syntax:

=SUMPRODUCT(array1, [array2], [array3], ...)

array1, array2, ...: Ranges or arrays of the same size.

https://docs.google.com/spreadsheets/...