summing values appearing in col B when col A has been filtered

  • Thread starter Thread starter choc_penguin
  • Start date Start date
C

choc_penguin

In sheet 1 I have two columns:

Column A has a list of 10 entries of 4 different people, randoml
repeating.

(Bob, Sally, Bob, Dave, Sarah, Sally, Sarah, Bob, Sally, Bob)

Column B has random values for each entry

(10, 13, 50, 56, 100, 250, 20, 35, 60, 25)

I have applied the autofilter so that I am able to see the 'values' fo
each person.

In sheet 2 I have two columns:

Column A with 4 entries of the 4 people sheet 1 is concerned with.

(Bob, Sally, Dave, Sarah)

In column B of sheet 2, I want totals to appear for each person b
summing the values that appear for each in sheet 1. (i.e. 120 for Bob)

I'm thinking it's got something to do with vlookup but that's as far a
i got!

Any help is much appreciated!

Thank
 
You want to sum using one criteria, so SUMIF can be used here - in B1
of Sheet 2 enter this formula:

=SUMIF('Sheet 1'!A1:A10,A1,'Sheet 1'!B1:B10)

Copy the formula into B2 to B4.

Hope this helps.

Pete
 
Back
Top