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 |
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 |
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 |
All times are GMT +1. The time now is 02:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com