Try here
http://www.vbaexpress.com/kb/getarticle.php?kb_id=235
or here
http://www.vbaexpress.com/kb/kblist.php
Hope this helps
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" <sol@discussions.microsoft.com> wrote in message
news:CC007FA4-1A54-4EA2-9748-D56A53A68DD2@microsoft.com...
>
I use =COUNTIF(D10:D100, "YES"). It works pretty good
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks