Count by color

This addin create a formula called countbycolor that helps to count all the values in same Color you select as criteria.

=Countbycolor(Criteria,Count range)

Criteria- The cell with the Color you want to count.

Count Range= Is the range of the for which you want the total count.

Click here to download addin