View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CB CB is offline
external usenet poster
 
Posts: 97
Default How to add numbers using criteria from another column

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