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!!! |
#2
|
|||
|
|||
I would use a Pivot Table. To learn more about them, see:
http://peltiertech.com/Excel/Pivots/pivotstart.htm HTH Jason Atlanta, GA -----Original Message----- 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!!! . |
#3
|
|||
|
|||
"=SUMIF((Range,Criteria,SumRange)"
as in SUMIF(D:D,"CE",B:B) gives the total for CE (=13) If CE is in cell Sheet2!A1, with the data in Sheet1 use =SUMIF(Sheet1!D:D,A1,Sheet1!B:B) in Sheet2!B1, then you can copy the formula down for the other locations -----Original Message----- 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!!! . |
Reply |
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 |