Multiple condition Sum in Ms Excel.

Multiplecondition sum. It is a array formula first in formula cell double click than CTRL+Shift+Enter it will add {} to the formulawhich will be visible in the formula bar only.

Positive/condition value sum by formula.

Positive/condition value sum by formula.Some times need different way sum that means all positive value or or all negative value or some condition apply for sum .By this function easy way performed and save time .