Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Subtotals with variable number of items
Ok, I must concede defeat and ask the VBA gurus out there for help.
I have a spreadsheet that I need to subtotal column C and Column D. Each time this spreadsheet is used, there may be a different number of line items than in previous or subsequent runs (I may have 39 lines one time, and 60 the next time). I have column headers in row "A" and I want the subtotal to be three lines below the last row of data. The spreadsheet is sorted with all rows with a value in column "C", then all rows with a a value in column "D". Is there a way to do this? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Subtotals with variable number of items
On 2 Jan, 18:35, brentm wrote:
Ok, I must concede defeat and ask the VBA gurus out there for help. I have a spreadsheet that I need to subtotal column C and Column D. *Each time this spreadsheet is used, there may be a different number of line items than in previous or subsequent runs (I may have 39 lines one time, and 60 the next time). *I have column headers in row "A" and I want the subtotal to be three lines below the last row of data. *The spreadsheet is sorted with all rows with a value in column "C", then all rows with a a value in column "D". * Is there a way to do this? Thanks in advance. Hi Brent, I may be missing your exact need but If you insert a SUM formula and then insert rows for new records above that line then a SUM formula will automatically expand to include the extended range. Have you got a sample workbook? Anthony http://www.excel-ant.co.uk |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Subtotals with variable number of items
Thanks. But, yes, I was not very clear as to my intentions. I have a macro
that runs, and I was hoping to add this ability into the macro. My goal is to have this basically 100% automated and this was the final piece that I was unable to figure out. If all else fails, then this step can be manual, but I was hoping to have it all automatic. Any other ideas? "excel-ant" wrote: On 2 Jan, 18:35, brentm wrote: Ok, I must concede defeat and ask the VBA gurus out there for help. I have a spreadsheet that I need to subtotal column C and Column D. Each time this spreadsheet is used, there may be a different number of line items than in previous or subsequent runs (I may have 39 lines one time, and 60 the next time). I have column headers in row "A" and I want the subtotal to be three lines below the last row of data. The spreadsheet is sorted with all rows with a value in column "C", then all rows with a a value in column "D". Is there a way to do this? Thanks in advance. Hi Brent, I may be missing your exact need but If you insert a SUM formula and then insert rows for new records above that line then a SUM formula will automatically expand to include the extended range. Have you got a sample workbook? Anthony http://www.excel-ant.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals of Items in A Column based on Spec. Values found in Colu | Excel Discussion (Misc queries) | |||
How to sum a variable number of items | Excel Worksheet Functions | |||
Count number of items in one column that have a value in another? | Excel Worksheet Functions | |||
Number of different items in a column | Excel Programming | |||
Count number of unique items in a column that contains duplicates | Excel Worksheet Functions |