| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I sumif on a font color in excel 2007?
I would like to do a conditional sum of a color coded column of numbers. Is
there any way to do that in Excel 2007? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I sumif on a font color in excel 2007?
=SUBTOTAL(9,A2:A100)
Select your range Data Filter Filter by color "edk" wrote: I would like to do a conditional sum of a color coded column of numbers. Is there any way to do that in Excel 2007? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: Can it SUMIF( ) using color as a condition ? | Excel Discussion (Misc queries) | |||
| how to view font color in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 Conditional Font Color How To? | Excel Discussion (Misc queries) | |||
| Sumif and base it on font color of cell | Excel Worksheet Functions | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
