You could try this alternate method which doesn't use VBA.

In 2003 you can specify the Format color to look for under
EditFindOptionsFormatFormat.

Select the color from the Patterns dialog and Find All.

In the found dialog box the first cell will be highlighted. Hold SHIFT key and
scroll down to bottom of dialog box and select last cell.

The selected cells can then be summed by right-click on Status Bar and "Sum".

Do for each color.


Gord Dibben MS Excel MVP

On Fri, 14 Sep 2007 04:14:00 -0700, pjenz
wrote:

How do I sum numbers in a row that has different colours. I want to sum
black colours and red colours separately