SUMIF? Question
 

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

SUMIF? Question
 

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

SUMIF? Question
 

=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

SUMIF? Question
 

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

On Jan 21, 11:20*am, aeddave
wrote:
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

SUMIF? Question
 

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

SUMIF? Question
 

Glad it worked.

"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

SUMIF? Question
 

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

SUMIF? Question
 

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