Forum Discussion
Solved
Excel COUNTA not working
I need to count the number of cells with a date in.
I have used =COUNTA(A3:A20)
It counts the amount of cells and NOT the amount with dates in
😞
Holly1165 COUNTA counts the number of cells in a range that are not empty. Dates are numbers, so if you only want to add those use COUNT.
2 Replies
- OMG, what a simple solution! THANK YOU
Holly1165 COUNTA counts the number of cells in a range that are not empty. Dates are numbers, so if you only want to add those use COUNT.
