I thought this would be a fairly simple formula but just dont seem to
be able to get the right syntax.

Rows in column B will contain the text, 'Nichs' or 'NMSFC'.
Rows in column C may contain Chr149 ”

At bottom of column C I need a count, where column B = 'NMSFC' and
column C has a ” in it.

I had a go at this with the following formula, but it doesn't work. I
have tried using AND but again cant quite get it right.
=IF($B:$B="NMSFC",COUNTIF(C5:C263,"*"),"")

Any advice or help would be appreciated as completely stuck and cant
find a previous post that helps.

Thanks Carl