Value of empty cell

[Tugrul Ebabil]

Hello,

I am using Syncfusion Essential Studio 5.1.1.47.

I have a grid with two columns and four rows :

A1 is empty
A2 = 1
A3 = 1

B1 = 10
B2 = 20
B3 = 30

I have a formula B4 = SUMIF(A1:A3,">0",B1:B3)
The resultat should be 50 but 60 is displayed.
What is wrong in my formula ?

Best regards,

Tugrul

[Administrator]

This is a defect that we will have to correct in our library code. If you have a zero in the empty cell, things work as expected. But if the cell is empty, then things fail.

You can create a direct trac support incident to track when there is a build available with it fixed.