I have a spredsheet that has a column of colours related to work i.e. Red,
white the a second column has numbers. I would like to use a function that
can add only cells that match certain colours. i.e if B2, 5,7,10 has Red and
D25.7.10. has value but the imbetween cells have different colours. I need to
be able to use a some to only add up the value in column D which relate to
Red in column B.

Can anyone help on this one.

Thank you

Take a look he

http://cpearson.com/excel/colors.htm

In article ,
PK wrote:

I have a spredsheet that has a column of colours related to work i.e. Red,
white the a second column has numbers. I would like to use a function that
can add only cells that match certain colours. i.e if B2, 5,7,10 has Red and
D25.7.10. has value but the imbetween cells have different colours. I need to
be able to use a some to only add up the value in column D which relate to
Red in column B.

Can anyone help on this one.

Thank you

Thank you what I should of said is that the colour is in text Format i.e Red,
White.
--
pk


"PK" wrote:

I have a spredsheet that has a column of colours related to work i.e. Red,
white the a second column has numbers. I would like to use a function that
can add only cells that match certain colours. i.e if B2, 5,7,10 has Red and
D25.7.10. has value but the imbetween cells have different colours. I need to
be able to use a some to only add up the value in column D which relate to
Red in column B.

Can anyone help on this one.

Thank you

There is no built-in function to allow you to count colours directly,
so you have to make use of a user-defined function to return the
colour of a cell, and then count this. JE gave you a link to Chip
Pearson's site which shows how to do it - here's another link to Bob
Phillip's site which covers the same topic:

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

Read one of them !!

Hope this helps.

Pete

On Oct 25, 7:05 pm, PK wrote:
Thank you what I should of said is that the colour is in text Format i.e Red,
White.
--
pk



"PK" wrote:
I have a spredsheet that has a column of colours related to work i.e. Red,
white the a second column has numbers. I would like to use a function that
can add only cells that match certain colours. i.e if B2, 5,7,10 has Red and
D25.7.10. has value but the imbetween cells have different colours. I need to
be able to use a some to only add up the value in column D which relate to
Red in column B.

Can anyone help on this one.

Thank you- Hide quoted text -

- Show quoted text -

Try this:

=Sumif(B:B,"Red",D:D)

OR
Enter the color you're looking for in another cell, so you can change it
without having to change the formula itself, say A1.

Then try this:

=Sumif(B:B,A1,D:D)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"PK" wrote in message
...
Thank you what I should of said is that the colour is in text Format i.e
Red,
White.
--
pk


"PK" wrote:

I have a spredsheet that has a column of colours related to work i.e.
Red,
white the a second column has numbers. I would like to use a function
that
can add only cells that match certain colours. i.e if B2, 5,7,10 has Red
and
D25.7.10. has value but the imbetween cells have different colours. I
need to
be able to use a some to only add up the value in column D which relate
to
Red in column B.

Can anyone help on this one.

Thank you