Handsontable: SUMIF support for optional sum_range

Created on 3 Jul 2020  路  1Comment  路  Source: handsontable/handsontable

Description

According to https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b SUMIF function also accepts third, optional argument which will be used as a sum range if provided. Signature looks like:

SUMIF(range, criteria, [sum_range])

However, it seems like Handsontable doesn't support this option and uses only the first range if criteria succeed.

The original issue has been reported at https://github.com/ckeditor/ckeditor4/issues/4133

Steps to reproduce

  1. Open https://codepen.io/jacekbogdanski/pen/LYGeBOK
  2. Verify the value of C1.

Your environment

  • Handsontable version: 7.4.2
  • Browser Name and version: Chrome Version 81.0.4044.122 (Official Build) (64-bit)
  • Operating System: Linux Fedora 31
Formulas Bug
Source
picture jacekbogdanski
👀1

Most helpful comment

True. There's something wrong with the calculation. We should get 30 in C1.

picture AMBudnik on 3 Jul 2020
👍2

>All comments

True. There's something wrong with the calculation. We should get 30 in C1.

AMBudnik picture AMBudnik on 3 Jul 2020
👍2
Was this page helpful?
0 / 5 - 0 ratings

Related issues

azyubin picture azyubin  路  27Comments
budnix picture budnix  路  24Comments
mpetris picture mpetris  路  24Comments
AMBudnik picture AMBudnik  路  24Comments
ohadb1 picture ohadb1  路  28Comments