COUNTIFS

=COUNTIFS([Item Status]:[Item Status], "In Progress", yodr:yodr, >=[Start Year]@row, modr:modr, >=[Start Month]@row, yodr:yodr, <=[End Year]@row, modr:modr, <=[End Month]@row, [NSH Priority]:[NSH Priority], " ")

I am using this formula bove which is not calculating for me the count that is right, instead gives a value 0.

The same formula when I change the NSH Priority to Low, it gives me the right output,

can somone help, any comments is appreciated

Answers