Re: CountIFS greater and less than statements
Just to be clear. The formula COUNTIFS($D:$D,U$1,$K:$K,"<>12345") will search column D for all values equal to the value in U1. For those values found in D it will look in the corresponding row of column K and count the values there that are not equal to 12345. Is that what you want?