COUNT counts numbers, COUNTA counts any non-empty cell, and COUNTIF/COUNTIFS count cells that meet conditions. Pick the one that matches what you're counting.
Do it with AI insteadCount numbers
Use =COUNT(range) for cells containing numbers.
Count non-empty cells
Use =COUNTA(range) to count everything that isn't blank.
Count with a condition
Use =COUNTIF(range, criterion), e.g. count "West".
=COUNTIF(Region, "West")COUNT counts only numbers; COUNTA counts any non-empty cell including text.