Reference Sum() from another worksheet in the same workbook

Aspose.Cells Product Family
1

My issue is that I have a formula on a worksheet =SUM(H6:H6) which at run time will have a proper total from however many rows the dataset contained.

I need this total to be included on another sheet and I do not seem to find how to have this in my static template.

What is the proper syntax?

You can refer to the uploaded file on the LPL Gross Tab and the last tab Components of Claims Expense

2

Hi,


Thanks for providing us template file and some details.

Well, since you are referring to SUM of the data rows against Smart Markers in a worksheet, so, the might not find any concrete way to accomplish your task. The reason is Smart Markers are dynamic which insert rows dynamically based on your dataset, so you cannot know how many rows would be inserted before hand. I think you may try to create a named range based on your summary cell (H7) on the worksheet “LPLGross”. For example, you may specify the name as “LPL_Gross_Summary”. Now in your last sheet cell (F8), you may set a formula “=LPL_Gross_Summary” on the cell if this works for your needs.

Thank you.