SUM with WHERE

  • Thread starter Thread starter Peter Carlson
  • Start date Start date
P

Peter Carlson

I have one sheet with a bunch of records that look like:
Name, Lang, Qty
Peter, English, 5
Peter, French, 2
Dave, English, 7
....

On a second sheet I want to create a summary of the records:
English, 12
French, 2

So What I am kind of looking for is this:
English, =sum of $DRECORDS where Lang=English
French, =sum of $DRECORDS where Lang=French

Any ideas how to do this in excel?
Peter
 
Back
Top