Count If AND

Rodrigo Blotte
Rodrigo Blotte ✭✭✭
edited 12/06/23 in Formulas and Functions


I am trying to build a formula in which I can count an item from a list as long as it meets 2 criteria:

1- Item submission is in JANUARY

2- A dropdown selection is "No"

I truly cannot wrap my head around making the right formula so it gives me the appropriate result as I do not know how to build a count IF formula that looks for an IN BETWEEN date.

Please help.

This is what I have done so far which most likely is wrong.

=COUNTIFS(AND({Quarterly R1 Submission Date} >=DATE(2022, 12, 31), {Quarterly R1 Submission Date} <=DATE(2023, 2, 1)){Quarterly R1 Return 1}, "No")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!