Or just:

=COUNTIF(E5:E10,"<>Vaccant")

You're more likely to get a correct answer if you quote the correct cell references and/or formulae and/or post a sample workbook (as you can see)

Regards, TMS