Countifs - 2 field ranges plus a date


I am trying to create a formula to count companies (1st column) that we won a project(2nd shows win/lose) in certain date ranges (example Q1 - January to April of 2020)

I can get the count formula right that counts companies that we won the project with, can't figure out how to narrow it down with the date added into the formula.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!