| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 :Summing specific cells of a particular color in a colu
I have an excel worksheet in which a column contains some cells in which the
monetary values are coloured blue. Is there some function I could use to sum only these coloured values ? I have been told to use the SUMIF function , but I am unsure how to use it with respect to coloured fonts. Suggestions most welcome. Regards -- FLYNNE |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 :Summing specific cells of a particular color in a colu
"SumIf" will not serve the purpose.
Try using conditional Formating & SumIf together. Use same condition in Conditional Formating & SumIf "FLYNNE" wrote: I have an excel worksheet in which a column contains some cells in which the monetary values are coloured blue. Is there some function I could use to sum only these coloured values ? I have been told to use the SUMIF function , but I am unsure how to use it with respect to coloured fonts. Suggestions most welcome. Regards -- FLYNNE |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 :Summing specific cells of a particular color in a colu
Visit Chip Pearson's site for working with colored cells.
http://www.cpearson.com/excel/colors.htm See the SumByColor Function. Gord Dibben MS Excel MVP On Fri, 18 Aug 2006 05:12:01 -0700, FLYNNE wrote: I have an excel worksheet in which a column contains some cells in which the monetary values are coloured blue. Is there some function I could use to sum only these coloured values ? I have been told to use the SUMIF function , but I am unsure how to use it with respect to coloured fonts. Suggestions most welcome. Regards Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
| How Do I have excel count 2 cells with conditions (Excel 2003) | New Users to Excel | |||
| Merge cells in Excel 2003 doesn't show up on Format Alignment | Excel Discussion (Misc queries) | |||
| Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
| Excel 2003 isn't updating my cells | Excel Worksheet Functions | |||
Linear Mode
