You need to copy the UDF provided into a standard code module in the VBE.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"aaronwexler" wrote in message
...
Thanks for that website, but I tried to ues the formulas there and I just
get
errors. Is there something else I have to do other than use those
formulas?

"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.ColourCounter.html, but note the
constraints

--

HTH

RP
(remove nothere from the email address if mailing direct)


"aaronwexler" wrote in message
...
I have a question about how to write a formula to include specific
info in
a
range of cells. I have a range of cells I want to include in a
formula
but I
want the formula to only include the values that I have colored
Yellow. I
could select each yellow one by hand but I want this formula to work
for
data
I continue to add in the future which is way I want to have a large
selection
of cells. So for example if I want the sum of all the yellow values
in
this
range =SUM(C2:E65536) how could I write the formula to do that?

I would also like to write a formula that would count only the
negative
numbers. For example in the range =COUNT(C2:E65536) how could I write
the
formula to only include the negative or possitive numbers?

Thanks Aaron