Hello,

I am using following formula, when Sheet = Payment cell D9:D1000 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!$D 9:$D1000="Clear"),(Payment!$W9:$W1000))

Hi

I'm not sure that I understand your question, but my guess is that you want
to wrap the formula in an IF()
=IF$K614<1,"",
SUMPRODUCT((Payment!$G9:$G1000=$K614)*
(Payment!$D9:$D1000="Clear"),(Payment!$W9:$W1000)) )

--
Regards
Roger Govier

"Tufail" wrote in message
...
Hello,

I am using following formula, when Sheet = Payment cell D9:D1000 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!$D 9:$D1000="Clear"),(Payment!$W9:$W1000))

Your result cell must be formatted as DATE hence the result 0 is shown as
0-Jan-00.

If you don't want to show 0s then format the cell with CUSTOM format #;;;@

"Tufail" wrote:

Hello,

I am using following formula, when Sheet = Payment cell D9:D1000 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!$D 9:$D1000="Clear"),(Payment!$W9:$W1000))

No probs with your formula...Check the cell format///
--
If this post helps click Yes
---------------
Jacob Skaria


"Tufail" wrote:

Hello,

I am using following formula, when Sheet = Payment cell D9:D1000 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!$D 9:$D1000="Clear"),(Payment!$W9:$W1000))