Referencing cell value in COUNTIF formula does not work, while referencing static criteria (i.e. "Blue") works fine.

Good day,

I have found that using the formula COUNTIF(A:A, "Blue") returns the correct count, but using COUNTIF(A:A, B1) returns zero, so I cannot utilize the formula dynamically and this is required as the text in B1 can change.

Thanks.

3 Replies

BR Backia Raj Kanagaraj Syncfusion Team March 23, 2018 11:54 AM UTC

Hi Travis, 
 
We have checked the reported issue with our sample. But we were unable to reproduce the issue. Please find the sample and video link for your reference,  
 
 
 
If the issue still persists at your end, please modify the above sample to reproduce the issue. So that we will be able to analyze the issue better and update you with solution. 
 
Regards, 
Backia Raj Kanagaraj 



TC Travis Chambers March 23, 2018 12:15 PM UTC

I was unable to open the sample due to an assembly reference discrepancy, however I did try the formula in the "FormulaDemo" that comes in the Essentially Studio Sample folder and the formula does not work there either.

For example, if you go to the "Formula Support" worksheet and select an empty cell and type COUNTIF(A:A,"Secondcolumn"), it returns '1' because A24 = "Secondcolumn." But, if you type COUNTIF(A:A,A24) it returns '0'.


BR Backia Raj Kanagaraj Syncfusion Team March 26, 2018 09:14 AM UTC

Hi Travis, 
 
We have checked the reported issue in Formula Demo as per your replication procedure with the current product version(v16.1.0.24). But we were unable to reproduce the issue,  please find the below sample video link for your reference, 
 
 
Regards, 
Backia Raj Kanagaraj 


Loader.
Up arrow icon