Posted 8 September 2017, 12:46 pm EST
Hello . i have problem about formulas.. can anybody help me..
i have 2 spread. One spread(First) consists of the data that i will compute and the other spread(Second) is for my computation. how will i make a formula getting the sum of each columns at my first spread ? i need to set the sum at my second spread. i tried using this but it does not work:
formula_value =Sum( FSPREAD1_sheet!A1:A5)
FSPREAD2.cells(0,1).formula = formula_value