If col B contains the embedded data as you mentioned below,
then you could try this instead, in D2:
=SUMPRODUCT((ISNUMBER(SEARCH(D$1,$B$2:$B$10)))*($A $2:$A$10=$C2))
Copy D2 across/fill down to populate. Adapt the ranges to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---
"BenF12345" wrote:
Thanks!! In trying to generalize I kind of screwed up my question. What if
the name sof the tests were embedded with other text in that cell. John's
Test 1, Ken's Test 1, Jane's Test 3 etc...
I still need to count the number of Test 1s', but I can't do it by saying it
will equal the heading in column D.

Thanks for the help. You guys are great!!