"RagDyeR" <[email protected]> wrote in message news:...
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!
=====================================================

"sks1379" <[email protected]> wrote in
message news:[email protected]...

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
------------------------------------------------------------------------
sks1379's Profile:
http://www.excelforum.com/member.php...o&userid=26954
View this thread: http://www.excelforum.com/showthread...hreadid=401729