How to do a COUNTA type formula - counting number of rows in a filter / list

[Tom_Graham]

I need to know if a list of values (using say SELECT or FILTER) is greater than 1 (great than 1 row / value in the list).

Using COUNT and SELECT together does not seem to work if the values in the list are TEXT, and not NUMBERS.

I believe in Google Sheets/Excel this is why COUNTA exists, as COUNT also does not work for text.

I tried using INDEX and then checking if the value in position 2 is ‘null’, but that does not work either.

Is there are way around this?
I have searched for this before but could not find anything, so gave up and just added formula into spreadsheet column instead. But would really like to solve this as its important calculation that is needed in some situations.

Many thanks,

[Marc_Dillon]

Tom_Graham:

Using COUNT and SELECT together does not seem to work if the values in the list are TEXT, and not NUMBERS.

COUNT( SELECT( table[text-column] , ... ) )

…does in fact work. What makes you think it is not working? How are you trying to use it?