Forum Discussion
Using =SUMIFS formula between different spreadsheets on SharePoint
Hi can you please show how would the final link look like when doing all the replacements?
Thank you
Let us say you have a file named "SalesData.xlsx" stored in a SharePoint library named "Documents" within a site named "SalesSite". You want to sum the sales amounts from a worksheet named "Sales" in this file based on certain criteria. Here is how the final link would look like after replacing placeholders:
=SUMIFS('[https://YourSharePointURL.com/SalesSite/Documents/SalesData.xlsx]Sales'!A1:A100, '[https://YourSharePointURL.com/SalesSite/Documents/SalesData.xlsx]Sales'!B1:B100, "ProductA")
In this formula:
- 'https://YourSharePointURL.com/SalesSite/Documents/SalesData.xlsx' is the full URL of the SharePoint file.
- 'Sales' is the name of the worksheet within the file.
- A1:A100 is the range of sales amounts you want to sum.
- B1:B100 is the range of criteria (e.g., product names).
- "ProductA" is the criteria you're using to filter the sales amounts.
Make sure to replace 'https://YourSharePointURL.com/SalesSite/Documents/SalesData.xlsx' with the actual URL of your SharePoint file, and adjust the worksheet name, ranges, and criteria as needed for your specific scenario. The text are edit with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
Thank you, unfortunately it did not work. I tried pasting data with link on the source data but it blocks the file.
regardless thank you for your help.
NikolinoDE Thank you for your help. I will bear that in mind when I set up the next spreadsheet. I went and combined all the spreadsheets into one spreadsheet with multiple tabs and it worked perfectly after that.
Thank you for your help.
Regards
Peter
- I'm glad you found a solution and I wish you much success with Excel.
