You can't use the left formula on a column like that, it works on single cells at a time, unless you put it in to an array formula.
When you are using "text" as your criteria, are you saying the cell will actually contain the word text somewhere within, or are you trying to say count if the...