| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Subtotals multiple columns
Gary L Brown Wrote: Create a 'Helper' column with a formula such as... =A2 & H2 Then use this column for the 'At each change in:' of DataSubtotals to create a subtotal in Col C. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "john liem" wrote: - How can I have subtotals of Col. "C" (sum of price) at each change in Col. "A" (product) or Col. "H" (country) on 1 line? I want to have the subtotals below the data line. Has somebody a VBA script for it? I am using Excel 2003, thanks. -- john liem - A very good suggestion and solution, thanks Gary !!! -- john liem |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals multiple columns | Excel Worksheet Functions | |||
| Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
| how do I filter for 1 variable in multiple columns | Excel Worksheet Functions | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
| Filtering Text Data from Multiple columns | Excel Worksheet Functions | |||
Linear Mode
