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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Tony2Far" wrote in message
...
i have a grid of numbers and i want to categorise them and then total by
those categories. the simplest way would be to colour code each cell and
do a
conditional sumation based on the colour. can i do this? if not, is there
another easy way to do this?