How to count cells with one background color from a range

[FvdF]

Dear forum readers,

I have been searching for a while for a formula that counts the cells from a given range that have a background color.

I have already found many but keep getting the error "NAME" or "VALUE"
The rgb color is 150/150/150.

Can someone give me the right formula so I can get on with my project again.

I am working with a NL version of excel 2019

With Regards,
FvdF

 

[Joe4]

It depends on how the background color was applied.

If the background color comes from Conditional Formatting, you can quite often use the exact same logic applied to Conditional Formatting in a COUNTIF or COUNTIFS formula to get what you want.

If the background color was manually applied, and doesn't really follow any pattern or logic, then you may have to use VBA (or some other clever workaround) to get what you want, as native Excel functions run off of cell values, not their formatting.

Here is a good article that shows various ways to do this: 6 Ways to Count Colored Cells in Microsoft Excel [Illustrated Guide] | How To Excel