adding numbers from column B, while condition on column A
 

Dear Axcel(lent) users,

I want to know the total number (added up) from column B, where certain
conditions apply in column A. I think sumproduct should be used, but not
quite shu

Column A Column B
Phase Total
1 1
2 2
3 3
4 4
1 5
3 6
2 7
1 8

So I want to see the total amount in B, when the phase in A = 1 (in the
above example this is 14).

Please help me !

Kind regards,

Jan-Willem

adding numbers from column B, while condition on column A
 

=SUMIF(A16:A22,"=1",B16:B22) Adjust data ranges as required


"The Fool on the Hill" wrote:

Dear Axcel(lent) users,

I want to know the total number (added up) from column B, where certain
conditions apply in column A. I think sumproduct should be used, but not
quite shu

Column A Column B
Phase Total
1 1
2 2
3 3
4 4
1 5
3 6
2 7
1 8

So I want to see the total amount in B, when the phase in A = 1 (in the
above example this is 14).

Please help me !

Kind regards,

Jan-Willem

adding numbers from column B, while condition on column A
 

or as you suggested

=SUMPRODUCT(--($A$2:$A$9=A2),($B$2:$B$9)) where a2 contains 1

Regards
Peter

"The Fool on the Hill" wrote:

Dear Axcel(lent) users,

I want to know the total number (added up) from column B, where certain
conditions apply in column A. I think sumproduct should be used, but not
quite shu

Column A Column B
Phase Total
1 1
2 2
3 3
4 4
1 5
3 6
2 7
1 8

So I want to see the total amount in B, when the phase in A = 1 (in the
above example this is 14).

Please help me !

Kind regards,

Jan-Willem

adding numbers from column B, while condition on column A
 

Thanx both of you !

adding numbers from column B, while condition on column A
 

sumif() will also work
=sumif(A2:A9,1,B2:B9)

"The Fool on the Hill" wrote:

Dear Axcel(lent) users,

I want to know the total number (added up) from column B, where certain
conditions apply in column A. I think sumproduct should be used, but not
quite shu

Column A Column B
Phase Total
1 1
2 2
3 3
4 4
1 5
3 6
2 7
1 8

So I want to see the total amount in B, when the phase in A = 1 (in the
above example this is 14).

Please help me !

Kind regards,

Jan-Willem