i would like to sum only highlighted text in a row

M

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?
 
G

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
 
Top