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