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 |
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) |