Hi All,
Can anyone help me with the below formula?
=OR(SUMIFS($L:$L,$Z:$Z,AH6,$H:$H,$AJ$2,$A:$A,$AI$2),SUMIFS($L:$L,$Z:$Z,AH6,$H:$H,$AJ$2,$B:$B,$AI$2),SUMIFS($L:$L,$Z:$Z,AH6,$H:$H,$AJ$2,$C:$C,$AI$2),SUMIFS($L:$L,$Z:$Z,AH6,$H:$H,$AJ$2,$D:$D,$AI$2))
It returns "True" instead of the actual value.
Basically I have combined below 4 SUMIFS into one formula. Either one should return a numeric value. The only difference is in the last criteria_range.
=SUMIFS($L:$L,$Z:$Z,AH6,$H:$H,$AJ$2,$A:$A,$AI$2)
=SUMIFS($L:$L,$Z:$Z,AH6,$H:$H,$AJ$2,$B:$B,$AI$2)
=SUMIFS($L:$L,$Z:$Z,AH6,$H:$H,$AJ$2,$C:$C,$AI$2)
=SUMIFS($L:$L,$Z:$Z,AH6,$H:$H,$AJ$2,$D:$D,$AI$2)
Bookmarks