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

[Travis Chambers]

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.

[Backia Raj Kanagaraj]

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,  

 

Sample: http://www.syncfusion.com/downloads/support/forum/136606/ze/referencecell-1101161716 

 

Video: http://www.syncfusion.com/downloads/support/forum/136606/ze/cells1503261508 

 

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 

[Travis Chambers]

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

[Backia Raj Kanagaraj]

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, 

 

Video link: http://www.syncfusion.com/downloads/support/forum/136606/ze/countformula180689633 

 

Regards, 

Backia Raj Kanagaraj