If this were Excel I'd use = COUNT(one row)

I’ve googled/searched this to death so my apologies if this already been answered as I’ve seen at least half a dozen similar questions but none helped me. Here is a sample dataset.

My apologies for the formatting! I saw this and added an attachment to better show it.

Column1      Column2     Column3

Row 1…Missing …3…9

Row2 …0…?Help? …9

Row3…1…9…0

So what I need to know is which rows have any cells containing text with a new column. One way to do this in Excel is COUNT(Column1 through Column3). I would hope to see the following:

Column1      Column2     Column3    NEW COLUMN

Row 1 Missing 3 9 2

Row2 0 ?Help? 9 2

Row3 1 9 0 3

With this new column I can now further process this data as needed. So in a nutshell, how would you count the number of cells in a row to differentiate to know which ones are text vs numbers?

Thanks in advance, I’ve seen many responses recommending Rule Engine, etc but it’s not clear how to achieve these results. Thanks again. Love this community.

m

Sample.1.xlsx