Sumproduct Help Needed:
Sumproduct in cell G2 is returning 99. But I want it to return 143
Reason - Add up 77 not 33 to the I column value of g1 – how can that be possible?
If there is a SGNumNew, then ignore the corresponding value of SGNum from the sumproduct sum and add the SGNumNew to the sumproduct