Hi,

I have a very very long list with intentional duplicates. Each school
name is repeated and paired with a different language and a count of
how many parents speak that language at home. So for example

Spanish - School1 - 28
Chinese - School1 - 10
Arabic - School1 - 5
Spanish - School2 - 28
Chinese - School2 - 10
Arabic - School2 - 5
Korean - School2 - 2

etc.

I want to sum up the totals for each school but there are 1,000+
schools which repeat without a set pattern. What formula could I use
to add totals for a set? I hope this is clear...