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.
Subscribe to:
Post Comments (Atom)
-
This formula helps to sumup based on multiple criteria. It is same as sumif but sumif support only one condition whereas sumif support mul... -
Copy= Ctrl+C Paste= Ctrl+V Paste Value= Menu Key(key between Windows key & Ctrl.)+V Paste Formula= Menu Key(key between Windows key ...
No comments:
Post a Comment