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...
Have you tried opening both Excel files at once and using formula? The below works on one drive. Have not tried on SharePoint though.
The formula seems like =SUM([Book1.xlsx]Sheet1!$E$6,A8) , where Book1.xlsx sheet 1 E6 is the remote excel reference?
The formula seems like =SUM([Book1.xlsx]Sheet1!$E$6,A8) , where Book1.xlsx sheet 1 E6 is the remote excel reference?