I have a column of prices, some of which are fill colored lavender (the rest are not colored)
Is there a cell formula which will sum together only the prices in the lavender cells?
Thanks.
Astrikor
I have a column of prices, some of which are fill colored lavender (the rest are not colored)
Is there a cell formula which will sum together only the prices in the lavender cells?
Thanks.
Astrikor
Only with VBA
One of many examples.
http://www.extendoffice.com/document...-by-color.html
If you are happy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
That's a pity!
Any other ideas?
Are those prices in anyway way different than the prices in white cells?.Is the any condition?
This way you can find an around solution to your problem.
The colored cells relate to prices for another distributor and are coded before I receive them together with the other prices as a single column.
A work-around might be to filter by color, and then to use =SUBTOTAL(9,range) to run the calc for you...the total will be wrong when you remove the filter
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
Is the coding "special"- different from others?
Can you attached a workbook?
Brilliant!
Thanks adyteo.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks