Countif with Month Formula

Hi,

Need help with something that should be quite simple. I need return the count of "quotes" created in January. Right now, I have the following:

=COUNTIFS({Quote Date Column}, MONTH(@cell) = 1,({Quote or Order Column},"quote")

Can anyone tell me what I need to change?

Greatly appreciated!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!