The easiest option would be to calculate the totals in the SQL script at the source.
SSIS cannot put formulas in an Excel sheet.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP