If you're really 'filtering' (that is, applying data filters), turn on the
filter FIRST, make a selection (eg Alan), and THEN use the autosum button.
Instead of a sum function, you'll get a subtotal, which will add just those
values that met the filter criteria.
Otherwise, use sumif: =sumif(b:b,"Alan",a:a)

"Visi" wrote:

Hi

I have a little problem on how to implement this functionality:

Let's suppose I have 2 coloumns in excel named Value and Name. What I need
to do is to achieve the sum of all the values of a certain name like this:

Value Name
20 Alan
30 John
25 Alan
12 Ana

The result I need is Total Value for Alan = 45