Sum of filtered data

V

Visi

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
 
B

bpeltzer

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)
 
B

Billy Liddel

Visi

=SUMPRODUCT(--($B$10:$B$13=B10)*($A$10:$A$13)) where b10:b13 contains names
b10 contains the name you want and a10:a13 contains the values

Regards
Peter
 
Top