I have a fairly simple countif function that counts how many items are 90 days old or more.
But all this is returning is a value of 0, when I know that there are at least 8 items over 90 in that column. I've tried removing the "=" and just having ">90" and it still returns a 0. The column in question is formatted numerically. My only thought is that there are a few cells in column H that have a dash ("-") instead of a numerical value. Would this be throwing off the entire function? Oddly enough, if I put
=COUNTIF(PROCFilter!H2:H,"=100") it returns the correct value of 1.
I'm anticipating an obvious answer, but I've been staring at this sheet forever and I lost my brainpower.