I typed the following formula in and is displays the formula in the cell just
as it was typed in instead of calculating the formula.

=COUNTIF(C8:Q8,"=''")

Those are two single quotes after the equal sign.

What do I need to change or check?

Les