It is not IFERROR. It is formula SUMPRODUCT.
If I replace complex SUMPRODUCT-formulas with simple  =A1 → code works.

SUMPRODUCT- formulas example from Excel-file:

=SUMPRODUCT(('Sheet0'!$E$2:$E$300=$B$5)*('Sheet0'!$R$2:$R$300=$B50)*('Sheet0'!L$2:L$300))/SUMPRODUCT(('Sheet0'!$E$2:$E$300=$B$5)*('Sheet0'!$R$2:$R$300=$B50)*('Sheet0'!L$2:L$300>0)*(1))

=SUMPRODUCT(('Sheet0'!$E$2:$E$300=$B$5)*('Sheet0'!$R$2:$R$300=$B38)*('Sheet0'!H$2:H$300))

=IFERROR(SUMPRODUCT(('Sheet0'!$E$2:$E$300=$B$5)*('Sheet0'!$R$2:$R$300=$B45)*('Sheet0'!L$2:L$300))/SUMPRODUCT(('Sheet0'!$E$2:$E$300=$B$5)*('Sheet0'!$R$2:$R$300=$B45)*('Sheet0'!L$2:L$300>0)*(1));0)

=IF(D23="";SUMPRODUCT(('Sheet0'!$E$2:$E$300=$B$5)*('Sheet0'!$R$2:$R$300=$B74)*('Sheet0'!H$2:H$300));D23)



--
View this message in context: 
http://apache-poi.1045710.n5.nabble.com/Apache-POI-delete-the-cached-results-from-the-file-tp5728446p5728448.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org

Reply via email to