calculate the number of words in a row whose length is greater than 2

[sks1379]

Hi,
My requirement is thus...
I have multiple rows with one word in each cell...at the end of each
row i need to find the number of words in that particular row whose
length is greater than 2.
Any thoughts please?
Thanks
Kiran.

 

[duane]

something like this - count # of cells in a3:d3 with length >2

=SUMPRODUCT((LEN(A33)>2)*1)

 

[RagDyeR]

Try this:

=SUMPRODUCT(--(LEN(A1:Z1)>2))

And copy down as needed.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message
Hi,
My requirement is thus...
I have multiple rows with one word in each cell...at the end of each
row i need to find the number of words in that particular row whose
length is greater than 2.
Any thoughts please?
Thanks
Kiran.

 

[sks1379]

Hi,
Thanks a lot for both the response...as both seem to b
working....look forward to bombarding u guys with q's again..
Thanks again..
Regds
Kiran

 

[duane]

HTH

Note you could get a count of a range of lengths by

=SUMPRODUCT((LEN(A33)>2)*(LEN(A33)<XXX))

where XXX is the upper limit of length you want to count, such as 5