Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Color coded cells
What forumula can I use to total the different color cells I have in a column?
Column D 5.25 yellow 3.22 green 2.19 yellow 5.12 red 9.12 green yellow 7.44 green 12.34 red 5.12 I know how to sum the column, or add the separate colors myself. Is this possible? Thanks for your help. You are all so helpful. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Color coded cells
Taxmom,
Have a look at Chip Pearson's solution at http://www.cpearson.com/excel/colors.htm -- Hope this helps, MarkN "taxmom" wrote: What forumula can I use to total the different color cells I have in a column? Column D 5.25 yellow 3.22 green 2.19 yellow 5.12 red 9.12 green yellow 7.44 green 12.34 red 5.12 I know how to sum the column, or add the separate colors myself. Is this possible? Thanks for your help. You are all so helpful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
Merge Cells | Excel Discussion (Misc queries) | |||
Use the Merge & Center Button with unprotected Cells - sheet prote | Setting up and Configuration of Excel | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |