Formula that can count based on text & date criteria

[KimuraBandit]

Hi All,

I need help finding a formula that can count based on text & date criteria.

I need to count the number of jobs based on the analysis code and then by the required dates before today.

I have managed to get both formulas working separately by COUNTIF, and when I combine them by COUNTIFS, it does not help.

My current formula is =COUNTIFS('Raw Data'!C:C,A1,'Raw Data'!H:H,"<"C16).

Any suggested?

Thanks, Ashley

 

[Fluff]

What version of Excel are you using? "Prefer not to say" does not really help us.

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

You need to add an & like

=COUNTIFS('Raw Data'!C:C,A1,'Raw Data'!H:H,"<"&C16)

 

[KimuraBandit]

That worked, thank you.

I have also updated my account details.

 

[Fluff]

You're welcome & thanks for the feedback.

I have also updated my account details.

Thanks for that