Lesson#57: Simple trick to count rows by color

Lesson#57: Simple trick to count rows by color

 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.

1. I will add a Filter in the columns.

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

3. Go to Filer and click Filter by Color.

count rows by color
count rows by color

4. Now it shows a count of rows by color.

count rows by color
See also  Short Tips#0025: How to paste a column reverse?

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

*