Solved: Count a different cells depending on what colout the font is???

[anthony20069]

Hi guys,

Need your expert help again ,

Now I dont know if this is possible.....

Bassically (as what the title says) - is it possible to add a cell depending on what colout the font is

So......

In cell E1 there needs to be a total of Coloumn E:5:E17 (there is text in these cells) but only count them if they are red

Is this possible????

Cheers

[Bob Phillips]

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

[anthony20069]

Ok thanks for poiting me to that site - i tried what they suggested but when i use

[vba]=SUMPRODUCT(--(ColorIndex(E5:E45,TRUE)=3))[/vba]

it brings up this error

[vba]#NAME?[/vba]

any ideas?

*** didnt name the cell range

now i have named the cell range to "comp_actions" but am getting this error now

[VBA]#REF![/VBA]

????

[Bob Phillips]

You have to install the macro code on that site as well.

[anthony20069]

Ok so I have put that macro in the sheet I want this to happen, but it is still giving me the #ref! error... am i doign something wrong (well obv i am :P )

[Bob Phillips]

Post your workbook so that we can see.

[anthony20069]

Attached sample worksheet....

thanks for the help btw

[Bob Phillips]

You need to move the code from the worksheet module into a standard code module, and change the formula to

=SUMPRODUCT(--(ColorIndex(Completed,TRUE)=3))

etc.

[anthony20069]

awsome.... thanks very much for that, really appreciate it....