What is the limit of rows for which the COUNTIF function can be used? I use Excel to analyze survey responses and I have tried to use the COUNTIF function to count the number of "5s", "4s", "3s", etc., in a range of survey responses. The function works fine for a range of 20 or 30 cells, but fails if the range is a few hundred cells. The DCOUNT function works, but is more awkward and time consuming to use.
Is there something I'm missing?