Something like

=SUMPRODUCT(--(ColorIndex(A1:A100,TRUE)=3),--(A1:a100="adv"))

--
HTH

Bob Phillips

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

"Hamish" wrote in message
...
I would like the extend this now. The above link works fine, thankyou.

How would I change this to be conditional. For example

I have 2 Coloumns, The first coloumn contains a list of numbers

1.1 (req)
1.2 (adv)

I would like to count the number of Cells that are a particular colour in
Coloumn two and are of type (req) in the same row of colomn 1 and then the
same for adv in colomn 1. I have some ideas but I am only Familiar with C.

I would be greatful for some help. Thanks

"Bob Phillips" wrote:

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)

"Hamish" wrote in message
...
Hi

I have an Excell sheet with about 200 lines. My results are calssified
in
Columns in 5 Different colours. I would like to automatically count
the
number of cells with a particular background colour in each coloumn.

For example:

Look at one whole column and count how many cells have a green
background.

is this possible?