T
Tufail
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,)),"",VLOOKUP($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
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,)),"",VLOOKUP($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