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.
OMG, what a simple solution! THANK YOU