COUNTIF, Comparisons, and Cell References
While using the COUNTIF/COUNTIFS functions in Excel, I ran across a problem where the formula wouldn’t run. Needless to say, this is very frustrating. A simple numerical comparison works fine: =COUNTIF(A1:A10,”<10″) But a comparison using a cell reference does not…