Export to Excel Total Column Formula

sendoh

hi guys,

is it possible to export to excel with column formula, i checked the function filtertoformula in excel buffer table and it seems only the row total formula are there by using this '..' range.

this is what I'm trying to achieve.

Account no. | Name | 01/01/08 | 020108 | Total-here is the formula
700.090.98 | Expense | 300.00 | 200.00 | 500-here is the formula
700.090.99 | Expense | 500.00 | 200.00 | 700-here is the formula

please help...
\thanks

easabangan

Ricky boi,

Simply just use the excel buffer table to export in excel. And for the formula use the SetFormula function.

sendoh

the formula is just a sum of the column not the row.. how to achieve this?

ajhvdb

Can't you use export the literal value:
=C3+D3

sendoh

what is the possible way? any suggestion?

jonsan21

Using the literal value is possible when using automation.

sendoh

Using the literal value is possible when using automation.

give me some hints..

I'm on the Budget-> export to excel.. when exporting it, the formula in total column should be add..