ExcelBanter - View Single Post

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