COUNTIF contains Text

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

3

Will the range be supported in the future?

4

Hi Alaina,

Would you please elaborate in what kind of situation you will need this? Cause if you are looking up in a subtable, you only have to refer to its field header.

5

Hello Amy!

I was looking to shorten formulas. In the form view, our profit field adds up about 10 fields. Another example is when I am concatenating an address into one field. But now that I think about it, I can understand why this wouldn’t work in Ragic since we can move fields around as we like, and the formulas update.

1 Like