# Count If AND

✭✭✭✭
edited 12/06/23

Hi!

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.

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")

• edited 12/06/23

The COUNTIFS function assumes multiple criteria, so you don't need the AND function. Try this:

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

I hope that helps.

Matthew

• ✭✭✭✭

Thank you @Matthew J McAteer

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!