I am using countif to count the number of times certain values (the numbers 1 - 77) appear in a column, but when I use autofill, the criterion does not increase incrementally. That is, I have countif(F:F, 1), countif (F:F, 2), countif(F:F, 3) etc. When I drag, that series repeats (123, 123, 123, etc.) How do I get autofill to increase the criterion stepwise?
Solved by F. F. in 28 mins