i would like to sum only highlighted text in a row

[Mike]

I have an excel spreadsheet with 2 different colored cells (highlights). I
am trying to count only cells of a certain color. Is this possible?

 

[Pete_UK]

Chip Pearson shows how it can be done here:

http://www.cpearson.com/excel/colors.aspx

You can download the macros/UDFs involved.

Hope this helps.

Pete

 

[Gord Dibben]

Couple of methods.

1. See Chip Pearson's site for his SumByColor function.

http://www.cpearson.com/excel/colors.aspx

2. If your version of Excel is not older than 2003 you can find by
format then select these and see the SUM on the Status Bar.

Select your range and Edit>Find>Format.

Select the color pattern and Find All.

In the 'Found" dialog box hit SHIFT + down arrow.

Click on Status bar and select "SUM"

If you really mean "Count" the same methods apply.

Chjp has a CountByColor


Gord Dibben MS Excel MVP