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

Hi,

I'm struggling with the logic here

A B C D
10 1 10 20 A1=B1 & C1=D1 so you sum C1 & C2
10 1 10 20 The logic breaks down on this line.
10 2 12 12
15 1 12 23
15 1 11 23
16 5 12 12
17 2 12 12

Please explain.

Mike


"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. 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

I of course meant

A B C D
10 1 10 20 A1=A2 & B1=B2 so you sum C1 & C2
10 1 10 20 The logic breaks down on this line.
10 2 12 12
15 1 12 23
15 1 11 23
16 5 12 12
17 2 12 12

"Mike H" wrote:

Hi,

I'm struggling with the logic here

A B C D
10 1 10 20 A1=B1 & C1=D1 so you sum C1 & C2
10 1 10 20 The logic breaks down on this line.
10 2 12 12
15 1 12 23
15 1 11 23
16 5 12 12
17 2 12 12

Please explain.

Mike


"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. 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

Lets see if I can help

Colum A and B has a set of numbers that need to sum the total in c if the
numbers in A and B combined are duplicated on rows. Does this help?

"Mike H" wrote:

I of course meant

A B C D
10 1 10 20 A1=A2 & B1=B2 so you sum C1 & C2
10 1 10 20 The logic breaks down on this line.
10 2 12 12
15 1 12 23
15 1 11 23
16 5 12 12
17 2 12 12

"Mike H" wrote:

Hi,

I'm struggling with the logic here

A B C D
10 1 10 20 A1=B1 & C1=D1 so you sum C1 & C2
10 1 10 20 The logic breaks down on this line.
10 2 12 12
15 1 12 23
15 1 11 23
16 5 12 12
17 2 12 12

Please explain.

Mike


"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. 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

Look at line 2 thats were you have to start with your logic(make line 1
all zeros or whatever)

So then the logic is (If A2=A1 and B2=B1 then D2=C2+C1) OR (If A2=A3
and B2=B3 then D2=C2+C3 ) else D2 = C2

Jeremy wrote:

Lets see if I can help

Colum A and B has a set of numbers that need to sum the total in c if the
numbers in A and B combined are duplicated on rows. Does this help?

"Mike H" wrote:


I of course meant

A B C D
10 1 10 20 A1=A2 & B1=B2 so you sum C1 & C2
10 1 10 20 The logic breaks down on this line.
10 2 12 12
15 1 12 23
15 1 11 23
16 5 12 12
17 2 12 12

"Mike H" wrote:


Hi,

I'm struggling with the logic here

A B C D
10 1 10 20 A1=B1 & C1=D1 so you sum C1 & C2
10 1 10 20 The logic breaks down on this line.
10 2 12 12
15 1 12 23
15 1 11 23
16 5 12 12
17 2 12 12

Please explain.

Mike


"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. 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