Forum Discussion
UpbeatJo
Apr 28, 2021Copper Contributor
COUNTIFF function returning a zero
Hi there, I'm new to complex formulas (!) and looking to create a COUNTIF to track the number of leads from a variety of sources* within a date range. The sources are in a drop down list and I ...
JKPieterse
Apr 28, 2021Silver Contributor
I suspect the column with dates actually contains text values rather than dates. Select that column, click Data, Text - to - columns and click Finish, this normally resolves this issue.