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 : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Value of empty cell

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 [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.

CONFIRMATION

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.

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

;