Conditional Summing

SUMIF

SUMIFS

For more information, refer to the SUMIFS Function page.

SUMPRODUCT

For more information, refer to the SUMPRODUCT Function page.

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}

For more information, refer to the Array Formulas page.