COUNTIFF function returning a zero

Copper Contributor

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 would like the date range to be easily adjusted to give a monthly result (this is my D6 for start date and F6 for end date)

 

My 1st argument is B13:B101 for the source eg website

2nd argument is C13:C101 for the date of the enquiry

My formula looks like this:

=COUNTIFS($B13:$B101,B111,$C13:$C101,">="&$D6,$C13:$C101,"<="&$F6)

 

I want the outcomes to appear in a table where I can track number of leads from website, social media etc in a given range for one of my clients but the value is coming out as zero.

 

I have changed the date format to year,month,day with the year as 4 digits but still no joy.  Any advice would be massively appreciated!

Thanks so much :)

Jo

 

 

2 Replies

@UpbeatJo 

In general formula shall work if in D6 and F6 are dates (actually they are numbers), not texts which looks like dates. Format doesn't matter.

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.