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