I have a matrix with two columns. The first column contains names while the
second contains values. I would like to sum all values that matche the string
in the first column, so for example
A B
1 Mike 200
2 Alex 100
3 Frank 110
4 Alex 180

and the matching string is Alex, the returning valus is 280

thanks

Try...

=SUMIF(A1:A4,"Alex",B1:B4)

or

=SUMIF(A1:A4,D1,B1:B4)

....where D1 contains your criterion, such as 'Alex'.

Hope this helps!

In article ,
"Marco" wrote:

I have a matrix with two columns. The first column contains names while the
second contains values. I would like to sum all values that matche the string
in the first column, so for example
A B
1 Mike 200
2 Alex 100
3 Frank 110
4 Alex 180

and the matching string is Alex, the returning valus is 280

thanks

Hi, Marco,
Try: =SUMPRODUCT(((A1:A4)="Alex")*(B1:B4))
Regards.

--
JRod
Microsoft MVP - Excel
http://EXCELer.blogspot.com

"Marco" escreveu na mensagem
...
I have a matrix with two columns. The first column contains names while the
second contains values. I would like to sum all values that matche the
string
in the first column, so for example
A B
1 Mike 200
2 Alex 100
3 Frank 110
4 Alex 180

and the matching string is Alex, the returning valus is 280

thanks