SUMIF? Question

  • Thread starter Thread starter aeddave
  • Start date Start date
A

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
 
If the colors were in A1:A100 and the values in D1:D100, 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
 
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.
 
Back
Top