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
tauqeeracma
Jul 11, 2019Steel Contributor
- RRouxJul 04, 2023Copper Contributor
tauqeeracma Hello, I wanted to count say how many appointments someone had in a given month so trying =COUNTIF('Appointments’!O4:O2974,"=">"01/07/2023,<31/07/2023") I'm using the format the dates are in that range. It's returning 1 when there are many more there? Any help appreciated thanks.
- tauqeeracmaJul 04, 2023Steel Contributor
Hi RRoux
You can use COUNTIFS() function to achieve your requirements. Please refer to the attached sample file for more understanding.
Hope it will help you.
Thanks
Tauqeer
- beigemcDec 06, 2023Copper Contributor
- Johnny557Jun 05, 2022Copper Contributor
- Cheryl4242Jul 11, 2019Copper Contributor
tauqeeracma THANK YOU SO MUCH! I didn't even know this was an option! Thank you!
- SergeiBaklanJul 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