Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotals showing 0 in summary level// 2 subtotal levels | Excel Discussion (Misc queries) | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
all subtotals have summary except one | Excel Programming | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |