Forum Discussion
Dejia
Jun 26, 2026Occasional Reader
#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...
SergeiBaklan
Jun 26, 2026Diamond Contributor
It could be using of curly quotes instead of straight one, could be some typo, whatever. Better if you share screenshot with formula and indicate on which Excel platform/version you are.