If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|