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

HTH

Bob

"Opal" wrote in message
...
I have a range of cells and I need to count how many
have a blue background and a cell value of "C" and how
many have a green background and a cell value of "C"

I can count all the cells in the range that are blue or
green and I can count all the cells that contain the
value of "C", but how can I count the combined
criteria?

I'm thinking I just need some algebraic help... :-S