how do I count the number of times a word is repeated in a range?
 

Adapted from Dave Peterson's fine earlier post...........

=SUMPRODUCT(LEN(A1:C101)-LEN(SUBSTITUTE(UPPER(A1:C101),UPPER(D1),"")))/LEN(D
1)

Vaya con Dios,
Chuck, CABGx3


"sol" wrote in message
...

Try here

http://www.vbaexpress.com/kb/getarticle.php?kb_id=235
or here
http://www.vbaexpress.com/kb/kblist.php

Hope this helps


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=387033

sol Wrote:



I use =COUNTIF(D10:D100, "YES"). It works pretty good


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=387033