How to fix COUNTA issues in Microsoft Excel [When COUNTA is Still Counting Empty Cells]
The COUNTA function in Microsoft Excel is supposed to count non-empty cells. But it doesn't always work. This video shows you how to troubleshoot & work around issues with the COUNTA function using the ROWS function and the COUNTIF function.
If you're encountering COUNTA errors - namely the COUNTA function is counting empty cells, this quick tutorial will show you to fix those problems using the COUNT & COUNTIF functions.