Formulas for Summing Colums

[Guest]

What formula would I use when trying to sum a column of numbers but two
colors were used for different items and I need to sum each color separately

 

[Guest]

-----Original Message-----
What formula would I use when trying to sum a column of numbers but two
colors were used for different items and I need to sum each color separately
.
You should use the =Sum() formula...all you need to do

is highlight the color that you want to sum first after
you type in =Sum(

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.ColourCounter.html
and
http://www.cpearson.com/excel/colors.htm