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
|