Finding out number of occurrences of string in one column?

PS.

I nearly forgot to mention, the count figure will be used with an IF statement in a procedure to decide what to do next, so the result will be assigned to a variable.

PS.

I nearly forgot to mention, the count figure will be used with an IF statement in a procedure to decide what to do next, so the result will be assigned to a variable.

Hi

Countif will do what you want.

=countif(range,criteria)

Jacob

Thanks :o)

I forgot to mention I would rather not have to use a worksheet function, at the moment I insert a row enter the formula into A1 then use that (I have to insert a row because any row could be deleted depending on the result), but with a lot of linked data in the sheet this slows down the procedure considerably. I was hoping somehow I could use Count and to get it counted using VBA?

Regards,

Gary Hewitt-Long

try this application.worksheetfunction.countif()