Countifs - 2 field ranges plus a date

Simon Jordan

Hi,

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.

David Tutwiler

I think you're going to need to add something like:

IF(AND([Date Column] > DATE(2020, 01, 01), [Date Column] < DATE(2020, 03, 30), Q1)