Lesson#57: Simple trick to count rows by color
![Lesson#57: Simple trick to count rows by color](https://excelabcd.co.in/wp-content/uploads/2018/03/excelabcd-lesson-57.png)
Can you count rows by color? Yes, It’s very easy and simple. Here I have a data table that has different colors in rows. I have counted rows by color in these simple steps.
![](https://excelabcd.co.in/wp-content/uploads/2018/03/57-1.png)
1. I will add a Filter in the columns.
![](https://excelabcd.co.in/wp-content/uploads/2018/03/57-2.png)
2. Add this formula =SUBTOTAL(2,A2:A52) and this should be on that column where the rows have unique values. (Example: Serial No.)
![count rows by color](https://excelabcd.co.in/wp-content/uploads/2018/03/57-3.png)
3. Go to Filer and click Filter by Color.
![count rows by color](https://excelabcd.co.in/wp-content/uploads/2018/03/57-4.png)
![count rows by color](https://excelabcd.co.in/wp-content/uploads/2018/03/57-5.png)
4. Now it shows a count of rows by color.
![count rows by color](https://excelabcd.co.in/wp-content/uploads/2018/03/57-6.png)
Leave a Reply