I am trying to find a way of using a formula for a large range of data that
would do a sum if formula or equivalent. Below is an example of what I am
looking of knowns are what is in columns a, b and c. D is where the formula
is. It needs to give the totals of what is in c if a and b match. In terms
I am wanting d to be the sum of c if the data alike in a and b. So rows 1
and 2 added is 20 because a is 10 and b is one.


A b c d
1 10 1 10 20
2 10 1 10 20
3 10 2 12 12
4 15 1 12 23
5 15 1 11 23
6 16 5 12 12
7 17 2 12 12