I want to count the rows when sum between cells of C and D columns is non-zero (i.e. greater than 0). As shown in image, I want to calculate value using formula which should be 3.
I tried countif and countifs formula, but not giving expected result.
Any help would be appreciated.
>Solution :
Try:
=SUM(N(MMULT(C2:D5,{1,1})>0))
