Thread: SumProduct
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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