Count text responses and blanks together

[Liverlee]

Hi can anyone help me with this problem. In Column A - I have a series of multi choice answers, yes, no, maybe, etc etc. And i also have blanks where no responses have been given.

I'm trying to come up with a formula that adds up both the "no" responses and the blanks, is this possible?

i've tried =COUNTIF(C2:C1082,"No")+COUNTA(C2:C1082) but that doesn't seem to give the correct number.

 

[Fluff]

How about
=SUM( COUNTIF(C2:C1082,{"No",""}))

 

[Liverlee]

Spot on fluff, thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.