CountIF formula with 3 criteria help please

ealexis ✭✭
edited 03/01/24 in Formulas and Functions


I am trying to use the CountIF formula with 3 criteria.

1st criteria: date needs to between between 12/31/2023 and 5/5/2024

2nd criteria: intake status needs to be not blank

3rd criteria: must match zip code

I am getting "incorrect argument set". Can anyone help?

This is my formula below:

=COUNTIFS({BROWARD UP REQUEST INFORMATION created}, >=DATE(2023, 12, 31), {BROWARD UP REQUEST INFORMATION created}, <=DATE(2024, 5, 5), {Intake Status}, <>"", {zipcode}, "33309")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!