Hi,

I'm trying to automate some formulas without using long formulas or name manager.

My issue is I have 5x "criteria" (same column), but need to SUM only those criteria with an overall positive balance(balance sheet).

I can't use this formula below because it doesn't consider the closing balance per criteria (assets/liability).
=SUM(SUMIF(X:X,{"Criteria1","Criteria2","Criteria3","Criteria4","Criteria5"},P:P))

My current solution:-
=IF(SUMIF(X:X,"Criteria1",P:P)>0,SUMIF(X:X,"Criteria1",P:P),0) + IF(SUMIF(X:X,"Criteria2",P:P)>0,SUMIF(X:X,"Criteria2",P:P),0) + IF(SUMIF(X:X,"Criteria3",P:P)>0,SUMIF(X:X,"Criteria3",P:P),0) + IF(SUMIF(X:X,"Criteria4",P:P)>0,SUMIF(X:X,"Criteria4",P:P),0) + IF(SUMIF(X:X,"Criteria5",P:P)>0,SUMIF(X:X,"Criteria5",P:P),0).

Any feedback would be appreciated!

Cheers, T