Forum Discussion
Cheryl4242
Jul 11, 2019Copper Contributor
COUNTIF to count cells with dates in them
It's so simple, but I can't make it work.... I have a column where a date will be entered for some cells. I just want to count the cells with dates in them. The other cells will be blank. I've tr...
- Jul 11, 2019
Cheryl4242
Jul 11, 2019Copper Contributor
tauqeeracma THANK YOU SO MUCH! I didn't even know this was an option! Thank you!
SergeiBaklan
Jul 11, 2019MVP
COUNTA() is the best in this case, but if check non-blanks with COUNTIF/COUNTIFS it looks like
=COUNTIF(G3:G20,"<>")
- MIDE_001Jul 07, 2021Copper Contributor
This was really helpful...thank you
- SamCanoJan 14, 2021Copper Contributor
SergeiBaklan thank you!! That´s what I was looking for!!!
- SergeiBaklanJan 14, 2021MVP
SamCano , glad to help