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 any advice on how I can stop this from happening?