Excel 2003 :Summing specific cells of a particular color in a colu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
"SumIf" will not serve the purpose.

Try using conditional Formating & SumIf together.

Use same condition in Conditional Formating & SumIf
 
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

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
Click to expand...

Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about conditional formatting of zeros in Excel 0
I need to count and / or sum cells with specific text colours. Hel 3
Conditional formatting in Excel 2010 2
Counting of cells with a specific color filled 9
Excel 2003; Lost Cell Shading 3
colour change as a result of a figure 1
Excel 2007: Can it SUMIF( ) using color as a condition ? 5
Cell Fill colours 2

Back
Top