=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