COUNTIFS with date range as criteria.

Justin Mauzy

I am trying to use the COUNTIFS formula with a date range. Here is what I have:

• 2 sheets
  • Attainment sheet (This is where the formula is)
  • Schedule sheet
• On the Schedule sheet, I am looking at 2 columns
  • Schedule Range 2 = Team column
  • Schedule Range 3 = Service Date column
• I am trying to see if the Team column contains a string of text.
• If it does, then count the number of items within a DATE range in the Service Date column.

=COUNTIFS({Schedule Range 2}, CONTAINS("ALBQCC01", @cell), {Schedule Range 3} AND(@cell >= DATE(2021, 02, 01), @cell <= DATE(2021, 02, 07)))

I am getting an #UNPARSEABLE error with the above code.

Thank you,

Bassam Khalil

Hi @Justin Mauzy 

Hope you are fine, please try the following formula:

=IFERROR(COUNTIFS({Schedule Range 2}, CONTAINS("ALBQCC01", @cell), {Schedule Range 3},
AND(@cell >= DATE(2021, 2, 1), @cell <= DATE(2021, 2, 7))), "")

Bassam Khalil

Hi @Justin Mauzy 

Hope you are fine, please try the following formula:

=IFERROR(COUNTIFS({Schedule Range 2}, CONTAINS("ALBQCC01", @cell), {Schedule Range 3},
AND(@cell >= DATE(2021, 2, 1), @cell <= DATE(2021, 2, 7))), "")

Justin Mauzy

That worked perfectly! Thank you for the quick response.

Bassam Khalil

@Justin Mauzy

Excellent, I will be happy to help you any time