Hi Trung,
Thanks for contacting Syncfusion support..!
We have confirmed the issue as "
SUMIF 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/49140/sumif-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.”
