Forum Discussion
=COUNTA Not Working
It was working but I wanted it to count 2 additional rows so I changed the range and it stopped working. The original formula was =COUNTA(E4:E24) I changed it to =COUNTA(E4:E26) instead o...
- Make sure that the cell with the COUNTA formula is not formatted as Text, but as General.
- Activate the Formulas tab of the ribbon. Make sure that the Show Formulas button in the Formula Auditing group is not highlighted.
Worked for me. Thanks.