dear all,

=COUNTIFS('AX DATA'!$K:$K,"*"&$A$1&"*",'AX DATA'!$Y:$Y,"*"&$A3&"*",'AX DATA'!$AP:$AP,">3")
am not able to get the result with the given formula. but if I remove the ">" signs only then I get the result.
so, I put the formula like,
=COUNTIFS('AX DATA'!$K:$K,"*"&$A$1&"*",'AX DATA'!$Y:$Y,"*"&$A3&"*",'AX DATA'!$AP:$AP,"2")+COUNTIFS('AX DATA'!$K:$K,"*"&$A$1&"*",'AX DATA'!$Y:$Y,"*"&$A3&"*",'AX DATA'!$AP:$AP,"3")

can't we put comparison operator in this formula. without using these operator length of the formula becomes soo long.
please help.