Forum Discussion
Using =SUM between two Excel Web Worksbooks
Hi, I am trying to use the =sum formula in the cell of an Excel workbook online by grabbing the data in cells from a separate online Excel workbook, but it doesn't seem to work. The two separ...
Yes, same way as in desktop. Open both files, start with =SUM( in one and select range in another. Entire formula looks like
=SUM('https://tenant.sharepoint.com/sites/SiteName/Shared Documents/folder/subfolder/[FileName.xlsx]SheetName'!$A$1:$A$100)
- Hi,
Thanks for the reply. When I try to do this it doesn't seem to grab the source data of the cells from the other workbook. Confused.
