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

Sum by Color

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

=Sumbycolor(Criteria,Sum range)

Criteria- The cell with the Color you want to sum up.

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

Click here to download addin


To add the addin go to

File-Options-addins-GO(at the bottom)-browse-paste the addin-double click on it-ok.