COUNTA
A function that counts cells that aren't empty, whatever they hold. Comparing it with COUNT reveals text stored where numbers should be.
A function that counts cells that aren't empty, whatever they hold. Comparing it with COUNT reveals text stored where numbers should be.