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

S

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

duane

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

=SUMPRODUCT((LEN(A3:D3)>2)*1)
 
R

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

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
 
D

duane

HTH

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

=SUMPRODUCT((LEN(A3:D3)>2)*(LEN(A3:D3)<XXX))

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