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

[Guest]

 

[CLR]

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

 

[keithl816]

Try here

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

Hope this helps

 

[Ltat42a]

I use =COUNTIF(D10100, "YES"). It works pretty goo