Excel formula to add color filled entries

[Fustrated in Edmonton]

I have been trying to figure out a formula so it will add only the specified
color filled entries. EX. I have a spreadsheet of 2000 lines. I want it to
add the 75 lines that I have highlighted yellow. Anyone have an aswer for me?

 

[Bob Phillips]

Take a look at

http://www.xldynamic.com/source/xld.ColourCounter.html
Processing Coloured Cells

--

HTH

RP

I have been trying to figure out a formula so it will add only the specified
color filled entries. EX. I have a spreadsheet of 2000 lines. I want it to
add the 75 lines that I have highlighted yellow. Anyone have an aswer for

me?