| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding Values Based on a Separate Column
I have a spreadsheet where the number of Items delivered is listed in Column
B and the location of where it was delivered in Column D. What I need to do is in a different Tab sum the values in Column B, but grouped by Column D. i.e ColumnB ColumnD 5 CE 6 CW 8 R1 8 CE And on the other tab I need to separately total each in Column D: CE 13 CW 6 R1 8 Thank you!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| How sum values in column B using values in column A as the conditi | Excel Worksheet Functions | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
| Cannot sum values based on condition | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
