Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any error in my SUMPRODUCT formula ?
Hello All,
I want to know if some error in my formula, I am using 2 list 1=SaleList 2=PaymentList and wanted bring payment clear date from PaymentList into SaleList, exp is as under : PaymentList A_1[Status] E_1[code] Y_1 [Date] Receivabe 100 20-May-2009 Clear 100 25-May-2009 =IF($AS1="Clear",SUMPRODUCT((PaymentList!$E$1:$E$5 000=$F1)*(PaymentList!$A$1:$A$5000="Clear"),(Payme ntList!$Y$1:$Y$5000)),$B$4)) This formula is in SaleList as well $AS1, $F1 & $B$4 are in SaleList too, $B$4 cell has current date, means if not clear status in PaymentList then come out current date and it's working but if status clear in PaymentList then came out #N/A error !, hope I explained well. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Formula Error, please help... ;o( | Excel Worksheet Functions | |||
Sumproduct returns value error when ref is formula | Excel Discussion (Misc queries) | |||
SUMPRODUCT formula returning #VALUE! error | Excel Worksheet Functions | |||
DIV/0! error in SumProduct formula with no division | Excel Worksheet Functions | |||
SumProduct Formula Error | Excel Worksheet Functions |