#name error

I keep getting #name error whenever I enter formula using countifs I adjusted the formula and ensured there were no typos and even using the formula tool and still keeps happening. Does anyone have a...