Troubleshooter of Error: Count Cells According to RGB Values

Count Cells According to RGB Values

Need a formula to count cells in a range according to RGB color settings.

Anwsers to the Problem Count Cells According to RGB Values

Download Error Fixer (Free)

Hi,
 
Here's a fairly non-flexible solution which you would call with this where A1:A20 is the range to sum
 
=CountRGB(A1:A20)
 
Function CountRGB(Rng As Range) As Long
Application.Volatile
Dim C As Range
For Each C In Rng
    If C.Interior.Color = RGB(255, 209, 209) Then
    CountRGB = CountRGB + 1
    End If
Next
End Function
 
And here's a more flexible version where we pass the colour to the function like this
 
=CountRGB2(A1:A20,A1)
 
Where a1 is the colour to count
 
Function CountRGB2(Rng As Range, col As Range) As Long
Application.Volatile
Dim C As Range
For Each C In Rng
    If C.Interior.Color = col.Interior.Color Then
    CountRGB2 = CountRGB2 + 1
    End If
Next
End Function
 
EDIT...
I should have added that this will re-calculate when Excel does but changing the colour of a cell does not trigger a re-calculation.

Make Sure that your System Meets the System Requirements

Microsoft Windows Requirements :

• 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
• 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
• 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your PC hardware is not up to par, then make sure you update where necessary before continuing.

Another Safe way to Repair the Problem: Count Cells According to RGB Values:

How to Fix Count Cells According to RGB Values with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Run it, and it will scan your system. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.

Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Troubleshoot:Conversion of Excel & Word Starter 2010 files by Microsoft without Warning or Notice,How to Resolve - Crash and reboot when creating a restore point or doing other system restore related things?,How to Fix - Counting data and automatically separating it into months for a table?,Troubleshooting:Could not find EbookLauncher.xml file!,Ctrl F in protected document? [Anwsered],Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly