Conditional Summing

SUMIF

SUMIFS

For a detailed breakdown, refer to the SUMIFS Function page.

SUMPRODUCT

Instead of multiplying your cell ranges by 1 ( *1 ) you can alternatively add 0 ( + 0) or use two minus signs ( -- ).
The plus sign ( + ) can be used to indicate an OR condition when the cell ranges are the same.
The plus sign ( + ) can be used to indicate an AND condition when the cell ranges are different.
Some formulas only work with unary and comma while others only work with multiply
You cannot use comma if they are not the same size ??

{SUM}