Forum Discussion

jinibob's avatar
jinibob
Copper Contributor
Feb 28, 2024

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 separate Excel workbooks are in the same SharePoint folder

 

Can anyone tell me how I do this?

 

Thanks

excel
Excel for web
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Feb 28, 2024

    jinibob 

    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)

     

    • jinibob's avatar
      jinibob
      Copper Contributor
      Feb 28, 2024
      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.
  • Skandel590's avatar
    Skandel590
    Copper Contributor
    Feb 28, 2024
    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?

Resources