Subtotals function offset subtotals summary
 

I have a worksheet where I need to sum records in one column by another
(thus subtotals function). As you know when excel sums each group of
records it records the subtotal at the bottom of the last record in the
same column. I need excel to record the subtotal at the bottom of each
group of records at the bottom of each group of records in the same row
but one (blank) colum over.
I have tried to count the records to the bottom of each group and copy
the subtotal to the next cell over with no sucess.
Thanks
Steve

ex. UPC Price Subtotals
10 1
11 2
12 3
Sub 6- 6

Subtotals function offset subtotals summary
 

1. Using your mouse pointer, select the cell where you want the
total(subtotal) to appearand click to activate the cell.

2. Click the Sum icon (Sigma) on the formula bar.

3. Move the mouse pointer to the beginning of the range you want to total,
click and hold until you select the complete range, then release the mouse
button.

4. Press Enter.

Repeat these steps for each range you want to subtotal.

"TimkenSteve" wrote:

I have a worksheet where I need to sum records in one column by another
(thus subtotals function). As you know when excel sums each group of
records it records the subtotal at the bottom of the last record in the
same column. I need excel to record the subtotal at the bottom of each
group of records at the bottom of each group of records in the same row
but one (blank) colum over.
I have tried to count the records to the bottom of each group and copy
the subtotal to the next cell over with no sucess.
Thanks
Steve

ex. UPC Price Subtotals
10 1
11 2
12 3
Sub 6- 6

Subtotals function offset subtotals summary
 

Thank you for the post, I apologize for not being specific. I am
attempting to adapt the VBA code for the subtotals funtion where it
populates the subtotal below the last cell attached to the by clause. I
want it to populate the adjacent cell to the right in an empy column in
VBA.
Any ideas??

JLGWhiz wrote:
1. Using your mouse pointer, select the cell where you want the
total(subtotal) to appearand click to activate the cell.

2. Click the Sum icon (Sigma) on the formula bar.

3. Move the mouse pointer to the beginning of the range you want to total,
click and hold until you select the complete range, then release the mouse
button.

4. Press Enter.

Repeat these steps for each range you want to subtotal.

"TimkenSteve" wrote:

I have a worksheet where I need to sum records in one column by another
(thus subtotals function). As you know when excel sums each group of
records it records the subtotal at the bottom of the last record in the
same column. I need excel to record the subtotal at the bottom of each
group of records at the bottom of each group of records in the same row
but one (blank) colum over.
I have tried to count the records to the bottom of each group and copy
the subtotal to the next cell over with no sucess.
Thanks
Steve

ex. UPC Price Subtotals
10 1
11 2
12 3
Sub 6- 6