http://www.cpearson.com/excel/CFColors.htm

I am trying to sum only the colored cells in a column range, and the colors
are applied with conditional formatting. Someone recommended the above page
to me, and it looks like exactly what I am looking for - I just can't get the
one function I'm after to work.

Onthis page, the IndexColorOfCF, ColorOfCF, and
CountOfCF all work for me. The SumByCFColorIndex does not return an error,
but it is always evaluating to zero. I am putting the range, then an integer
as the function arguments.

I tried 0,1,2,-1, and others to try and see if it would sum the values of
the colored cells in the range I specified. I tried to look at the code, but
I don't know what integer it is looking for for it to work.

It is the last function on this page. If this would work, I'm all set! If
someone who understands this code could tell me, that would be great.

Thanks for any help you can offer.