adding numbers from column B, while condition on column A

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 shure:

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
 
or as you suggested

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

Regards
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum value in all columns that their title is the same 1
Numbers from first column 5
sumproduct Column B based on Column A 6
Sumproduct Column B based on Column A 3
Sum a range based on a column 2
Group Total 2
adding differences between dates 6
Need help with SUMPRODUCT Formula 10

Back
Top