Have you looked in the help index for SUMIF?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"aeddave" wrote in message
...
I want to add the cells in column D, when their corresponding column A is a
specific label. For example,

Column A Column D
Blue 50
Black 35
Blue 21
Yellow 43

I want to sum the values in Column D by color (Blue=71)

Thanks for any help