Countifs formula

Cemil Binlik

Hi,

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.

Cemil Binlik

Never mind, I found my answer, my first reference name was incorrect as I wrote it manually. It took me a while to figure it out, Thank you

Cemil Binlik

Never mind, I found my answer, my first reference name was incorrect as I wrote it manually. It took me a while to figure it out, Thank you

Genevieve P.

Glad you were able to figure it out! 🙂