So you want to reference another spreadsheet in your Google sheet. So we have a couple of sales here from the last two years, and we're putting together a dashboard , but we're missing this year's sales. We've created a whole nother spreadsheet file, an entirely new workbook with these sales, and they're in a different column. How are we going to get this data into our dashboard ? I'm gonna show you how right now, so we're going to go just like we would with getting the sum of. This reference we're going to hit equals. The one difference we're gonna do is we're gonna import a range, and what we need here is a spreadsheet, URL and the range string. So that spreadsheet URL is literally the entire workbooks , URL. We'll put that in double quotes.

And the range string . We'll also put in double quotes and what it'll be is the name of the tab plus the range , so C. C. . This will be 2025 sales exclamation point. CC, we're gonna hit enter and it's gonna give us a reference error , but when we hover over it, it'll say allow access . So we need to connect these sheets and we may get another reference error that says the array would overwrite data in C3. That's because it's going to give us that whole range. So let's wrap some around this and there's our answer. we got the range from the other spreadsheet, the entire other workbook, and then we summed it up. Pretty cool, right? You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right

now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.