ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Any error in my SUMPRODUCT formula ? (https://www.excelbanter.com/excel-discussion-misc-queries/241801-any-error-my-sumproduct-formula.html)

Tufail

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.




Tufail

Any error in my SUMPRODUCT formula ?
 
Please Ignore my this message, problam already solved :)


"Tufail" wrote:

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.





All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com