To make the formula more robust, since the Find() function is case
sensitive, you can use the Search() function instead:

=SUMPRODUCT((A1:A100=C5)*(ISNUMBER(SEARCH(D5,B1:B1 00))))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"RagDyeR" wrote in message
...
Say you put the first name in a particular cell, say D5, then try this:

=SUMPRODUCT((A1:A100=C5)*(ISNUMBER(FIND(D5,B1:B100 ))))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Tendresse" wrote in message
...
i'm using the following formula to count the number of times a certain value
appears in column A when the value in column B=Dave. I want to adjust this
formula so that it counts the number of times a certain value appears in
column A when the value in column B 'contains' the string Dave. Cells in
column B may contain something like Dave Smith (not just Dave).

=SUMPRODUCT(--(A1:A100=C5),--(B1:B100="Dave"))

Thanks in advance.
Excel 2003.