Hello,

I want get date from Sheet "Payment" Cell add "C" but are not able to do so,
my formula and error is as under :

Case1: =SUMPRODUCT((Payment!$Q$9:$Q$500=AT205)*(Payment!
$P$9:$P$500<"100")*(Payment!$C$9:$C$500)) Error is showing #VALUE!

Case2:
=SUMPRODUCT((Payment!$Q$9:$Q$500=AT205),(Payment!$ P$9:$P$500<"100"),(Payment!$C$9:$C$500)) Error is showing 00-Jan-00

Payment list cells contain formulas, detail is as umder :

Q_Col
=IF($F9="","",IF(ISNA(VLOOKUP($F9,PmtND,9,)),"",VL OOKUP($F9,PmtND,9,)))

P_Cel
=IF($K9="","",$I9+$O9)

C_Cell (this cell has date)
=IF(ISBLANK($K9),"",IF($C9="",TODAY(),$C9))

Hope someone could help on it.

Thanks