Excel function pass range in string format argument

I want to pass a range in the excel function
eg: String.Format("=Sum({0})",Excel.Sheet(“Sheet1”).Range(“A2:B2”))

Please guide how to do it. Currently not able to pass the range

1 Like

Hey @shivam.gup,

Please check below workflow whether it solve your query.

If not, please let me know.

PFA FYR - ExcelFormula.zip (8.0 KB)

Thanks :slight_smile:

Actually i am writing it some other workbookand that excel file is currently in scope
and i am referring the resource excel for calculate the sum… so the values for sum i.e. range is coming from other excel file in current application scope . I am able to get to the cell value with this format but not the range.

1 Like