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.
=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.
No comments:
Post a Comment