We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

SUM AVERAGE calculation #VALUE! when If the first parameter is bracketed , and multiple cell

If the first parameter of sum formula and AVERAGE formula is bracketed, and multiple cell references separated by commas are used in the middle, one of which is not a numerical value, the formula calculation error occurs.

However, count is calculated normally. In addition, in version 20.1, sum and AVERAGE formulas can also be calculated normally.
image.png (22.3 KB)
image.png (22.0 KB)

there are codes and excel file.
EPPR-58764.zip (8.5 KB)

@xhaixia,
I have logged a separate ticket with an id “CELLSJAVA-45078” for your issue. We will look into it soon.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

  Issue ID(s): CELLSJAVA-45078

You can obtain Paid Support services if you need support on a priority basis, along with the direct access to our Paid Support management team.

@xhaixia,

We are pleased to inform you that your issue has been resolved now. The fix will be included in our upcoming release (Aspose.Cells v23.2) which is scheduled in the first half of February 2023. You will be notified once the next release is published.