You propose 3 answers, none of which seem to work, but by any chance have you tried the following:
=countif(E2:E223,"HP EliteBook 850 G7 Notebook PC")
i.e. no "s" for countif and no "=" sign in the parentheses. At least it works on my computer.