| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF using color
Is there a way to only add cells in a column that have a certain colored
font? I looked at the link at http://www.cpearson.com/excel/colors.htm but I couldn't figure out if this can be done or not. What I need specifically is a way to say: add G100 plus any numbers that are blue from G1:G99. Thanks in advance, Kris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif, criteria, fill color | Excel Discussion (Misc queries) | |||
| SUMIF function with text color condition | Excel Worksheet Functions | |||
| Sumif and base it on font color of cell | Excel Worksheet Functions | |||
| SUMIF on Fill color | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
