| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to add numbers using criteria from another column
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 "CB" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| How do I sum column D and F based on multiple column criteria? | Excel Worksheet Functions | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
| Add numbers in column b if date is between certain criteria | Excel Worksheet Functions | |||
Linear Mode
