Countifs between Dates with text range

[Colmans]

Hi

I'm struggling with a report that i'm wanting to generate. I have been able to report the total number of events between dates (month) using the following:

=COUNTIFS(createdon,">=" & C2,createdon,"<=" & EDATE(C2,1))

createdon = set range in data worksheet
C2 = Date (e.g 1st Jan 2017) showing as Jan-17

I now want to break this number down further by providing more criteria which applies to each entry. I've labelled the range "Decision" which contains a number or results and variations e.g Approved, approved with conditions, declined, etc. all as text.

I've tried to use the following but it returns a #Value error


=COUNTIFS(createdon,">=" & C2,createdon,"<=" & EDATE(C2,1),Decision,"*approved*")

If I remove the wildcard ** and just put the text I get the same error. I've also tried putting the decision argument at the front of the string and it makes no difference.

What am I doing wrong?

Thanks in advance for your assistance.

 

[steve the fish]

Id imagine the ranges are not the same length as a guess.

 

[arthurbr]

Do all ranges have the same length?

 

[Colmans]

Id imagine the ranges are not the same length as a guess.

Thanks to you both for the responses. All working!!