How to use COUNTIFS with two criteria? One is a date range.

Ryan Holguin
Ryan Holguin ✭✭✭✭
edited 07/06/22 in Formulas and Functions

Hello All,

I am working on gathers metrics for my team and need help figuring out how to use COUNTIFS with the following criteria:

  1. Check box is marked as complete
  2. The date is between 01/01/20 and 12/31/20

This will be an annual request, so the date will change year over year, but want to determine what my root formula will be.

Can you help?


Ryan H

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!