Currently in code i'm populating an excel file and grouping the data, now I
need to add a row with a total for each group, in code how can i add a total
of each group?

Example:
BMW
25,463
69,000
12,000

Total 106,463
Lexus
72,000
25,000
13,000
total 110,000

how can i accomplish something like this?