How to sum inside excel and I tried and getting expression expected

prasathsunkara · June 12, 2021, 3:23pm

kumar.varun2 · June 12, 2021, 3:40pm

Welcome to the UiPath Community.

try this-

"=SUM(L"+FirstRowIndex.ToString+":L"+LastRowIndex.ToString+")"

prasathsunkara · June 12, 2021, 4:16pm

Hello Varun

Thanks for quick reply!.
getting below error now-please assist.

Also do you have any contact number to talk and sort like assistance?

kumar.varun2 · June 12, 2021, 4:28pm

type the above statement into - * Open in Advanced Editor

prasathsunkara · June 12, 2021, 4:41pm

getting below error.

In general how to sum a column and get total in last column?-using studio X.
Since I’m new to this.

kumar.varun2 · June 12, 2021, 4:42pm

Change the scopes of FirstRowIndex and LastRowIndex variables from the variable pane.

prasathsunkara · June 12, 2021, 4:47pm

I’m sorry this is first time I’m using -what to enter in FirstRowIndex and LastRowIndex?

kumar.varun2 · June 12, 2021, 4:51pm

This is variable panel. In this panel all the variables in the workflow are listed. You can change the scope of variable from here.

prasathsunkara · June 12, 2021, 4:57pm

Variables not found in Studio X

kumar.varun2 · June 12, 2021, 4:57pm

Take a look in data manager

Also try entering like this in normal mode in write cell

Sum(L FirstRowIndex : L LastRowIndex)

prasathsunkara · June 12, 2021, 5:07pm

Data mgr shows this below

kumar.varun2 · June 12, 2021, 5:59pm

did it work?

prasathsunkara · June 12, 2021, 6:04pm

No my dear friend and ur awesome asking me again…
Posted my full requirement in below path-Kindly help me based on full expected result.

Thanks again so much!