We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Value of empty cell

Thread ID:





69537 Oct 31,2007 04:07 PM UTC Nov 1,2007 09:08 AM UTC WinForms 1
Tags: GridControl
Tugrul Ebabil
Asked On October 31, 2007 04:07 PM UTC


I am using Syncfusion Essential Studio

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,


Administrator [Syncfusion]
Replied On November 1, 2007 09:08 AM UTC

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.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon