Odd and pair words

Hi there!
How can we count odd and pair words from several column in a row?

I’ve not heard this term before. Could you explain what this means?

1 Like

I need to count how many odd words are in a row.
And also need to count even words that are in a row.
odd word= two (3 letters)
even word= four (4 letters)

That’s not really possible.

Can you provide a better picture of what the larger goal is? Why do you want to know how many three (or four) letter words there are?

1 Like

This is not tested, but maybe you can try to use SPLIT(), with a space as the delimiter, then COUNT(SELECT()) with a condition of
MOD(LEN()) = 0
or
MOD(LEN()) = 1

1 Like