{=COUNT(IF(B$20:B507=D$6,1,""))}

The above is my basic formula for the array yet where can I add another function within the above to count text strings etc....