SUMIF? Question

[aeddave]

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

 

[Don Guillett]

Have you looked in the help index for SUMIF?

 

[Gaurav]

=SUMIF(A1:A4,"BLUE",D14)

 

[JP]

If the colors were in A1:A100 and the values in D1100, this would
add the values in column D where it finds the value in parenthesis in
column A.

=SUMIF($A$1:$A$100,"Blue",$D$1:$D$100)

If you wanted to check multiple times, you could replace "Blue" with a
cell reference (ex: SUMIF($A$1:$A$100,E1,$D$1:$D$100)) then put the
color in E1 that you wanted to check.

HTH,
JP

 

[aeddave]

Thanks Gaurav. That did it.

=SUMIF(A1:A4,"BLUE",D14)

 

[Gaurav]

Glad it worked.

Thanks Gaurav. That did it.

 

[Don Guillett]

help would have done so, as well

 

[aeddave]

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.