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

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