Excel SUM Functions:
- SUMSQ – Square and Add Cell Values
- SUMPRODUCT – Multiply and Add Two Arrays
- SUMIF – Add with a Condition
- SUMIFS – Add with Multiple Conditions
- SUMX2PY2 – Add Sums of Squares of Two Arrays
- SMX2MY2 – Add Differences of Squares of Two Arrays
SUMIF(), Conditional Sum, is a wonderful function that allows you to find the sum of only selected cells in a table.
For example, let’s say you have a table of fish sales by quarters, fish types, regions, etc.
What if you wanted to find the sum of sales for the Atlantic and Pacific regions separately?
SUMIF() function is ideal for that kind of calculations.
General formula is:
range is the range where the CONDITION is to be found.
criteria is the cell that defines the CONDITION.
sum_range is the range of the values that you’d like to add.
For example, for ATLANTIC fish sales:
For PACIFIC fish sales:
And here are the results:
Conditional sums for TYPES OF FISHES: