in reply to Help with formula in excel
$Sheet->Range("H$lastrow4")->{Formula} = '=sum("H17:H.$Lastrow3")'; [download]
$Sheet->Range("H$lastrow4")->{Formula} = '=sum("H17:H.'.$Lastrow3.'")' +; [download]