SumifFormulaFunction's "matchCriteria" not 100% same as Excel's version
|Status:||In Progress||Start date:|
|Assignee:||Miro Eklund||% Done:|
|Velocity based estimate||-|
The current version of SumifFormulaFunction takes into account most situations, but will handle error-values differently than excel.
Update: Use attached xlsx-file to see the difference in criteria evaluation in excel. If a value includes an error-cell, such as #REF!, Excel will in the example case pass that error forward to SumIf's error. This is not the case in the current SumIf-formula.
When editing SumIf to be the same as Excel's, follow excel specifications for criteria:
"*criteria:* Required. The criteria in the form of a number, expression, a cell reference, text, or a function that defines which cells will be added. For example, criteria can be expressed as 32, ">32", B5, "32", "apples", or TODAY.
Important: Any text criteria or any criteria that includes logical or mathematical symbols must be enclosed in double quotation marks ("). If the criteria is numeric, double quotation marks are not required."
#6 Updated by Miro Eklund about 1 year ago
Tuukka Lehtonen wrote:
Miro, are there any changes related to this issue on the platform side?
As far as I know, there are no changes to this issue anywhere. SumIf criteria is still evaluated differently than in excel, but in most cases is handled correctly.