Build 4.5.0.23 of xlsgen has a fix for the calculation engine, for meeting a scenario where cells in error have to be ignored during the calculation of formulas using one or more of the following functions : IFS / SUMIF / SUMIFS / AVERAGEIF / AVERAGEIFS / MINIFS / MAXIFS / COUNTIF / COUNTIFS.