See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"kirkyringo" wrote in message
...
Hi everyone,
I am trying to add the numbers in fields that are highlighted in a
specific
colour. I believe this is done with the IF function, can someone assist
in
showing me how to put the formula together as an example.

Thanks.