LinkBack URL
About LinkBacks
Any here know how to sum values of a cell by colors?
Like for example, sum value of any cells in color Red multiplied to the number of quantity.
Any here know how to sum values of a cell by colors?
Like for example, sum value of any cells in color Red multiplied to the number of quantity.
It looks like those colors were added manually? If so, then no, no regular formula will count colors. Shading/color/font etc are cosmetic formatting, not data, and excel formulas work with data.
However, if there is some logic behind how the cells were colored, then all may not be lost, we may be able to create a formula based on that logic
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I got it to work for me using this user defined function below from ozgrid.com Worked well.
Please Login or Register to view this content.
Last edited by brocktoon93; 10-02-2014 at 07:36 AM.
http://www.ExcelbyJoe.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks