How to add numbers using criteria from another column

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

Guest

Can you help me figure out how to add numbers in one column based on criteria
from another column. I would like to add the numbers in between each time
Chris shows up on the chart below and put the total in a separate column.
example:
qty name total
1 chris
2 jon
9 jim
1 chris 11
34 joe
10 brad
4 jon
6 bret
2 chris 54

Can you help me? Thanks
 
an easy way is to use helper columns
(D:E??)
in D2 enter
=if(b2="chris",0,D1+A2)
in E2 enter
=if(B2="chris",if(isnumber(D1),D1,""),"")
copy D2 and E2 and paste down as far as you need to go.
Hide column D
 
You must log in or register to reply here.

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

Add/Subtract columns from tab to tab in same file 3
Excel Subtracting multiple columns from another column 3
Add from multiple criteria in a range 5
how to combine number data from one column into another column 1
Numbers from first column 5
Add a number '1' next to highest number in column 3
caluculate an average based on 2 criteria 3
finding the median from a list of unsorted numbers 2

Back
Top