Sriram
Reputation: 453
How to count rows of a particular column using formula in Google Sheet
I have a google sheet that contains case number column and MC column. How to count the row of case number based on the MC Column and automatically sum up in the number of cases column. This is the screenshot of my data:
Upvotes: 1
Views: 75
Answers (1)
player0
Reputation: 1
try:
=QUERY(A2:C; "select C,count(C) where C is not null group by C")
Upvotes: 1
Related Questions
- Count values in row where first column is value
- Count Rows with Text
- How to count all items in the cells of a column in Google Sheets?
- Count occurences in column
- Use Sheet's Array formula to count values in each row
- Count cells in Excel
- How to count rows in excel by using text
- Excel: How to count rows based on specific values in columns?
- Count by row on based on more than one column
- How to extract number of rows for every value in a column?