Dear Aspose Team,
i am trying to use COUNTIF on an excelsheet:
=COUNTIF(E$6:E$13;“>0”)
this returns 1, however:
=COUNTIF(MyTable[MyColumn];“>0”)
is evalulated properly
MyColumn is a column in my table which is exac…...version works, while the plain‑range version does not. Why it happens...and text values in the same range can cause COUNTIF to return...