Add subtotals in Excel

[spm1973 (Simone Paties)]

Hi, I have a robot that transforms a csv to excel. Then move and delete some columns (with BalaReva Easy Excel Package). So far so good. Now I should add subtotals, but I can’t understand how. Could anyone help me out?
Thanks
S.

[unknownay]

Hi @spm1973

You can write a cell =SUM(A1:A10). calculate the number if rows and write formula to last cell. datatable.rows.count to get the number of rows in a datatable

Regards
Roshan

NB: Mark as solution if found useful

[spm1973 (Simone Paties)]

Hi unknownay, thanks for the reply. However, what you suggest is to add the whole column. I need the subtotals of columns B and C everytime the value of column A changes.
Something like this: