Count colored cells in excel - Without VBA

In this video, we will look at two methods to count colored cells in Excel without using VBA (macros).

In this video, we will show you two ways to count colored cells in Excel

- Using GET.CELL function and CountIF formula
- Using Filter by Colour and SUBTOTAL function.

Click here to subscribe to my channel to get more videos of Excel formula tips and uses:

[nirakarbarik]

Is there any formula where it will only count on special color out of total

[doshikeyur]

Hello, Can you help me if cell color based on conditional formatting how we can count by color ?

[marcusryan]

your screen is very little you viewers can't see it clearly

[ruanribeiro]

This worked for me but it doesnt change automatically even when i set as automatic

[nims]

Hi
I want cell count with color in 10 sheet

[johnaquilina]

does not seem to work on cells that are colored but blank or cells with no numbers

[mikelennon]

My purpose is to find the identical background colors in a row not in columns while each the row has over 20 fields. And each cell's background color depends on its value (GREEN if meets the conditional formatting criteria). I can make this work if there is a way to get the dynamic color codes (GREEN) in other cells not exactly Right to each colored cells. Is there any way to get the color reference codes in another location not just next to the cell/s in question?

[gamerbreed]

It's not updating automatically upon making changes albeit calculation option is automatic.

[prees]

Countcell is not showing to me in my excel

[rubicxcibur]

Filter by color seems to work in columns but not in rows. I don't understand that.

[geraldterencio]

Is this still working until now? Because I only got 0 for my 3 difference color. My 3 colors(Standard Color): 1) Green; 2) Red; 3) Blue

[dimitrismpower]

Mine doesnt work (get.cell method). I follow the steps but when i write the CountCell function, it doesnt give me the color code

[wengcheng]

What formulas to count from A1 to D5 if have same item in one column.
Exp the 'paid' have total cell = 7

C1
Paid 12 15 16
75
Cash 46 87 95

C2
Paid 15 87 80
Cash 86 90 06

[aloysiuslan]

cant even follow uyp the countcell lol