Thread: Excel 2003 :Summing specific cells of a particular color in a colu
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote