Forum Discussion
Counting the number of rows by text value
I have a file with case numbers and case types in a given month. I want to know which case type is the most common. How can I get a count of the number of rows in each case type?
If case types are in Column C, the formula in D2 is:
=COUNTIF(C:C,C2)
Instead of C:C, you should instead use a dynamic range named CaseTypes, with this formula:
=INDEX($C$2:INDEX($C:$C,COUNTA($C:$C))
Thereafter, your formula in D2 should look like this:
=COUNTIF(CaseTypes,C2)
=COUNTIF(C:C,C2)
Instead of C:C, you should instead use a dynamic range named CaseTypes, with this formula:
=INDEX($C$2:INDEX($C:$C,COUNTA($C:$C))
Thereafter, your formula in D2 should look like this:
=COUNTIF(CaseTypes,C2)