On Fri, 26 Oct 2012 01:07:11 +0000, Qikstart wrote:


Spencer101;1606729 Wrote:
Care to post an example workbook?

Workbook attached.


+-------------------------------------------------------------------+
|Filename: counting multiple columns match with partial cell.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=642|
+-------------------------------------------------------------------+

Given your sample workbook data:

C9 : New
B10: =COUNTIFS($A$1:$A$6,$A10&"*",$B$1:$B$6,B$9)

Select b10 and fill/drag down one; then select B10:B11 and fill/drag to the right. The references should self adjust.