How does one programatically create subtotals, totals, and then GrandTotals.
I have data that once is entered I want to create the totals. I am keying off of the fact that in column a, there will either be numbers which represent skus, or the word Subtotal, Total, Grand Total.
Does anyone have a looping construct that will automatically create the sums in those indicated rows? The logic being that Subtotals are the totals of the prices above it. The Total is the sum of the just the subtotals above it, and finally the Grand Total is the sum of all the totals.
There can be multiple totals.
A | B
123 | 12.5
234 | 23.5
345 | 25.8
Subtotal abc
344 | 12.3
365 | 23.2
Subtotal bcd
Total = YYY (abc+bcd)
456 | 23.3
989 | 12.1
Subtotal cde
567 | 34.9
890 | 17.5
Subotal def
Total xyz (cde +def)
Grand Total XYXY (all totals)
Thanks
I have data that once is entered I want to create the totals. I am keying off of the fact that in column a, there will either be numbers which represent skus, or the word Subtotal, Total, Grand Total.
Does anyone have a looping construct that will automatically create the sums in those indicated rows? The logic being that Subtotals are the totals of the prices above it. The Total is the sum of the just the subtotals above it, and finally the Grand Total is the sum of all the totals.
There can be multiple totals.
A | B
123 | 12.5
234 | 23.5
345 | 25.8
Subtotal abc
344 | 12.3
365 | 23.2
Subtotal bcd
Total = YYY (abc+bcd)
456 | 23.3
989 | 12.1
Subtotal cde
567 | 34.9
890 | 17.5
Subotal def
Total xyz (cde +def)
Grand Total XYXY (all totals)
Thanks