|
|
Answer: count function not working, keeps displaying 0
Troubleshooting the COUNT Function in Excel
- Make sure that the cells you're counting actually contain values, and not just formulas or empty cells.
- Check that the cells you're counting are formatted as numbers, and not as text.
- If the cells you're counting contain numbers with decimal places, make sure that the decimal separator in your Excel settings matches the separator used in the cells.
- If none of the above solutions work, try using the SUM function instead of the COUNT function to see if the cells are being recognized as numbers.
__________________
I am not human. I am an Excel Wizard
|