sum values that are coloured in red

[stevekirk]

hi,

i am sure this will be a silly question but
is it possible to sum all the values within a range that are in red.

thanks steve

[oldchippy]

hi,

i am sure this will be a silly question but
is it possible to sum all the values within a range that are in red.

thanks steve

hi stevekirk,

Take a look at this link, it may help you

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

oldchippy

[stevekirk]

Hi,

thanks for link when i put the formular in i get the #name? error

any idea why

steve

[oldchippy]

Hi,

thanks for link when i put the formular in i get the #name? error

any idea why

steve

Hi steve,

It sounds like you need to paste the code in.
Copy the sample of code given on the link (towards the bottom of the page)and paste it into a module.
Do this by right clicking on the small xl icon next to file at the top left hand corner, select view code.
This will open the Visual Basic window, click Insert > Module
then click on Module1 in the project window
then click the large window on the right and paste the code in here
then click the X (close) top right hand corner.
Now with the code in place the formula should work
Select A1 and colour the cell, then in A2 =ColorIndex(A1)

Ok now?

[stevekirk]

HI,

i am still getting the #name? error please see sample file
thanks steve

[oldchippy]

See attached

[stevekirk]

HI,

Thank you very much for your help

why did mine not work?

steve

[oldchippy]

HI,

Thank you very much for your help

why did mine not work?

steve

Hi steve,

You put it in the wrong place, open the one I returned and you will see there is a Module, that is where the code is.

See attached link, this will explain more

http://www.mcgimpsey.com/excel/modules.html

oldchippy