Subtotals function offset subtotals summary

T

TimkenSteve

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
 
J

JLGWhiz

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.
 
T

TimkenSteve

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

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