| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining rows of like data?
=SUMPRODUCT(--(A2:A7="40-011"),B2:B7)
Adjuct range to suit. Note: SUMPRODUCT function does not work if you use a whole columns "Juggernaut" wrote: I have a spreadsheet that contains rows with multiple entries for the same item. How can I use a filter or a function to combine the values for the like items in to one row? Example: In the same chart, item number 40-011 appears three times with quantities of 5, 3, and 2. How can I filter the data so there is one occurence of 40-011 with a quantity of 10? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting all rows of data that have a value in a particular column | Excel Discussion (Misc queries) | |||
| Data: select a cell x rows below the current, where x is designate | Excel Discussion (Misc queries) | |||
| Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Hybrid Mode
