COUNTIF contains Text


#1

Hi All,

New here and I’m having a issue trying to figure out what I thought would be a simple formula.

Trying to COUNTIF contains text?

Excel formula would look like COUNTIF(A1:A5,"*")

Any help would be appreciated.

Thanks


#2

Hi,

It’s not supported to use “:” to range the fields in Ragic.

And if you are calculating the “non-empty values” of your “subtable records”, please use COUNTA(value) formula that it counts the number of cells that are not empty in a range.