|
SUMPRODUCT
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 |
SUMPRODUCT
SORRY PLEASE IGNORE MY REQUEST ! ! !
"Tufail" wrote: 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 |
| All times are GMT +1. The time now is 10:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com