Error Div/0 when use formula

[Ngoc Hoang]

Hi team.

I'm facing a problem. 

I want to use a formula like "AVERAGEIF, SUMIF, SUMIFS,...", however, I have an error. Thanks for your support.

[Sangeetha Priya Murugan]

Hi Hoàng,

Thanks for contacting Syncfusion support.

We have confirmed the issue as "AVERAGEIF formula returns wrong value as a result in spreadsheet component " and logged a bug report and it will be available in our First patch after Volume 4 release. You can track the status of the issue via the feedback link below.

Feedback link for tracking purpose: https://www.syncfusion.com/feedback/49348/averageif-formula-returns-wrong-value-as-a-result-in-spreadsheet-component

You will be informed regarding this once the fix is published.

Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works re prioritization.”