Add subtotals in Excel

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?

1 Like

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


NB: Mark as solution if found useful :slight_smile:

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: