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
-
With the COUNTIFS formula, you need to tell it what to count first, then give it one or more sets of criteria ranges and criteria.
=COUNTIFS({Quote or Order Column}, {Quote Date Column}, MONTH(@cell) = 1, {Quote or Order Column}, "quote")
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!