Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtotal by two columns at once
Hi,
I need to subtotal two separate columns at the same time in Excel. I have item numbers in one column and the corresponding quantity of each item in another column. Each item has many different rows. Using the Subtotals command under Data, I am only able to subtotal by the item number and then I have to go in manually and sum the quantities of each subtotaled item. Is there a way using Subtotals or something else to subtotal by item number and then sum up the quantity column related to each item number at the same time? Thank you, Katherine |
#2
|
|||
|
|||
Repeat the Subtotals command on the same cells by changing the 'At each
change in' value and removing the check mark for 'Replace current subtotals' Subtotal on your highest level first, then subtotal on the lower level. Hope this helps, Francis Hayes (The Excel Addict) http://www.theExcelAddict.com "Katherine" wrote: Hi, I need to subtotal two separate columns at the same time in Excel. I have item numbers in one column and the corresponding quantity of each item in another column. Each item has many different rows. Using the Subtotals command under Data, I am only able to subtotal by the item number and then I have to go in manually and sum the quantities of each subtotaled item. Is there a way using Subtotals or something else to subtotal by item number and then sum up the quantity column related to each item number at the same time? Thank you, Katherine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Subtotal And Countif | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) |