Countifs formula


I am trying to count the number of cells that have CX Planned value on the reference of CX Status Column and at the same time CX Month reference should be dated as 03-01-22, below don't seem to be working, when i do separate countif formula they work but of course don't give what i want. What am I missing here?

=COUNTIFS({CX MONTH}, DATE(2022, 3, 1), {CX Status}, "CX Planned")

It gives me incorrect argument set error.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!