T
Tufail
Hello,
I am using following formula, when Sheet = Payment cell D91000 doesn't
match value = Clear error value is coming in $K614 00-Jan-00 which I really
don't want, I just want as empty cell, is there any solution ?
=SUMPRODUCT((Payment!$G9:$G1000=$K614)*(Payment!$D9:$D1000="Clear"),(Payment!$W9:$W1000))
I am using following formula, when Sheet = Payment cell D91000 doesn't
match value = Clear error value is coming in $K614 00-Jan-00 which I really
don't want, I just want as empty cell, is there any solution ?
=SUMPRODUCT((Payment!$G9:$G1000=$K614)*(Payment!$D9:$D1000="Clear"),(Payment!$W9:$W1000))