SumProduct

[Ricardo]

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

 

[JE McGimpsey]

One way:

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

 

[Mike H]

Maybe:-

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

Mike

 

[Ricardo]

.... no

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

thanks

"Ricardo" escreveu:

 

[Mike H]

Hi,

What error?
What formula did you enter?

Mike

 

[Ricardo]

mike

I already foud the cause of the error.

thanks for you help

"Ricardo" escreveu: