Sum Formula
 

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.

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

Sum Formula
 

Jeremy,
First of all, the data supplied does not match the example given.
Following your description:
IF number in a is equal to b then you want the value that is in c to be in d.
Is this correct?
If so:
In cell D1, you need the following formula:
"=IF(A1=B1),C1,"NA")"
then just copy it down the D column as far as you need.
hth
"Jeremy" wrote:

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.

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

Sum Formula
 

On Thu, 7 Aug 2008 22:13:00 -0700, Jeremy
wrote:

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.

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


Try this formula in cell D1 and copy down as far as needed
Note: This is an array formula that has to be entered by
CTRL+SHIFT+ENTER rather than just ENTER.

=SUMPRODUCT((A$1:A$10=A1)*(B$1:B$10=B1),C$1:C$10)

Change the 10 to be large enough for your data

Hope this helps / Lars-Åke