COUNTIFS

_Adil

=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

jmyzk_cloudsmart_jp

Hi @_Adil

If you are counting items whose [MSH Priority] is blank, change " " to "".

 [NSH Priority]:[NSH Priority], " ") --->  [NSH Priority]:[NSH Priority], "")