Using COUNTIF together with a date range

deb_63_hydracor
deb_63_hydracor ✭✭✭✭✭✭
edited 06/17/22 in Formulas and Functions

Hello,

I'm trying to count how many rows meet this criteria (use a cross sheet reference):

Tier is Experiencia Lite (or whichever tier I need to count)

and

SLA was signed between 1/1/22 and 1/31/22 (will be doing this for each month)


This is what I have but iI get an unparseable error:

=COUNTIFS({Tier}@row,"Experiencia Lite", {SLA Effective Date} @row AND(@cell>=DATE(2022,01,01),@cell<=DATE(A2022,0131))


Thank you!

Tags:

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try these few edits to see if they help...


    Remove the "@row" references.

    Put a comma after the second range.

    Remove the "A" from the second DATE function.

    Insert a comma between the month and day values in the second DATE function.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!