countifs with a date criteria

drodgers
drodgers ✭✭
edited 12/09/19 in Formulas and Functions

I am trying to create a countifs formula that would count "New Quotes" with a  January date while it's referencing another sheet.

New Quotes would be in  the New Quote/Repricing column of this spreadsheet and then there's the Proposal date column that is in a MM/DD/YY format.

=COUNTIFS({CPI Prospects 2019 Range 1}, "New Quote", {CPI Prospects 2019 Range 2}MONTH(@cell),01)

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!