Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
SumProduct? | Excel Discussion (Misc queries) | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
hlp with sumproduct! | Excel Worksheet Functions | |||
sumproduct help | Excel Worksheet Functions |