SumProduct
 

Dear all

I need your help please.

I need to sum the values of a columm with a condition of the other columm

ex:
A B
Blue 100
Red 200
Blue 150
Blue 180

So what I need is the sum of columm B of the "blue" in columm A

Thanks

SumProduct
 

One way:

=SUMIF(A:A,"Blue",B:B)

In article ,
Ricardo wrote:

Dear all

I need your help please.

I need to sum the values of a columm with a condition of the other columm

ex:
A B
Blue 100
Red 200
Blue 150
Blue 180

So what I need is the sum of columm B of the "blue" in columm A

Thanks

SumProduct
 

Maybe:-

=SUMIF(A1:A10,"Blue",B1:B10)

Mike

"Ricardo" wrote:

Dear all

I need your help please.

I need to sum the values of a columm with a condition of the other columm

ex:
A B
Blue 100
Red 200
Blue 150
Blue 180

So what I need is the sum of columm B of the "blue" in columm A

Thanks

SumProduct
 

.... no

give me a error between the A10;"Blue";B1

thanks

"Ricardo" escreveu:

Dear all

I need your help please.

I need to sum the values of a columm with a condition of the other columm

ex:
A B
Blue 100
Red 200
Blue 150
Blue 180

So what I need is the sum of columm B of the "blue" in columm A

Thanks

SumProduct
 

Hi,

What error?
What formula did you enter?

Mike

"Ricardo" wrote:

... no

give me a error between the A10;"Blue";B1

thanks

"Ricardo" escreveu:

Dear all

I need your help please.

I need to sum the values of a columm with a condition of the other columm

ex:
A B
Blue 100
Red 200
Blue 150
Blue 180

So what I need is the sum of columm B of the "blue" in columm A

Thanks

SumProduct
 

mike

I already foud the cause of the error.

thanks for you help

"Ricardo" escreveu:

Dear all

I need your help please.

I need to sum the values of a columm with a condition of the other columm

ex:
A B
Blue 100
Red 200
Blue 150
Blue 180

So what I need is the sum of columm B of the "blue" in columm A

Thanks