Use formula like =SUM(B10:B29) to calculate the sum in cells from B10 to B29, or use a variable to store subtotals and their sum and display the variable value in the group total.

>I'm triying to fill an excel sheet trough automation, I store references to specifics cells that store subtotals to make a formula to a total, when the group is finish I try to store the formula in a cell and I got the message "Formula is too long" any workaround for this?.