I am using the code supplied by this link

http://www.xldynamic.com/source/xld.ColourCounter.html

To count the background colour of cells.

I have two coloumns the first column contains either R or A. The second
column contains coloured cells. I want to could how many cells are coloured a
certain colour and the other coloumn contains R.

I have the colour countring sorted and the Checking of R sorted by using
SUMPRODUCT by themselves but i cant get them to work together!

Thanks for your help.

Hamish