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.
Unfortunately, activation email could not send to your email. Please try again.

Value of empty cell

Thread ID:





69537 Oct 31,2007 12:07 PM Nov 1,2007 05:08 AM Windows Forms 1
Tags: GridControl
Tugrul Ebabil
Asked On October 31, 2007 12:07 PM


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 05:08 AM

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.

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.