View Single Post
  #1   Report Post  
Marco
 
Posts: n/a
Default how to find and add multiple entries

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