Sorry Don. I didn't mean to offend anyone. I did use help first, but still
could'nt figure it out. Gaurev was much clearer in his assistance and it
worked.

"Don Guillett" wrote:

help would have done so, as well


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"aeddave" wrote in message
...
Thanks Gaurav. That did it.

"Gaurav" wrote:

=SUMIF(A1:A4,"BLUE",D1:D4)

"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