Finance 3.0 - Social Network for Finance
Smart financial thinking
Excel Can Sum Colored Cells
Hi,
I recommend a website which will help those who have problems in summing colored cells in excell sheet.
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm
Regards,
Replies to This Discussion
-
Permalink Reply by Nurudeen Abolaji on -
I tried uploading those commands on the module as directed, but it never worked.
The command is not explicit as to where it begins.
Please help
-
Permalink Reply by nadine beyrouthy on -
Thx, great idea, it facilates the work
-
Permalink Reply by Sachidanand (Sacha) Singh on -
It works, thanks a lot.
The calculations are not automatic i.e. if I change the fill of the reference cell the formula does not give the new sum/ count till I take the curser to the formula bar and enter. Can it be automated, please?
Sign in
Badge
Continuing Education
 |
Accounting |
 |
Banking Regulations |
 |
Certification Training |
 |
Commercial Bank Management |
 |
Corporate Finance & Valuation |
 |
Treasury Management |
 |
Credit Risk Management |
 |
Financial Derivatives |
 |
Financial Institution Management |
 |
Financial Markets |
 |
Financial Modeling |
 |
Financial Planning |
 |
Market Risk Management |
 |
Operational Risk Management |
 |
Operations & Compliance |
 |
Quantitative Analysis |
 |
Strategic Financial Management |
Newsletter
Linkedin
RSS
Facebook
Widgets
Twitter© 2010 Created by Finance 3.0
