Incompatibility of the formula SUMIFS to its version in portuguese(SOMASES) at Excel 2013

Aspose.Cells Product Family
1

The Excel 2013 is not recognizing the SUMIFS formula as shown in the image attached.

Have anyone had the same issue?

The formula I used, bellow:

=SUMIFS(
table_a!C1:C1000,
table_a!A1:A1000,
“S”,
table_a!B1:B1000,
table_b!A1&" concat_any_string"
)


2

Hi,


Thanks for providing us some details.

Did you create the file (containing the SUMIFS formula) via Aspose.Cells APIs? Also, are you only facing the issue on Portuguese Excel? Did you test to open the file into English Excel version if it works fine. Could you provide the Excel file here, we will check it soon.

Thank you.