Subtotal by two columns at once

K

Katherine

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
 
F

Francis Hayes (The Excel Addict)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top