Thread
:
counting formula
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
counting formula
left(b1:b100,4)="dave"
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett