From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Using formulas to calculate values across worksheets and workbooks

Using formulas to calculate values across worksheets and workbooks - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Using formulas to calculate values across worksheets and workbooks

- [Instructors] For many users, 2 it's not uncommon to write formulas in some worksheets 3 that get data from other worksheets 4 within the same workbook. 5 Less common, but also needed at times 6 are formulas in one workbook that need to get data 7 from worksheets located in another workbook. 8 Let's cover some of these features. 9 In this workbook, linkage formulas, 10 we've got data for four different states. 11 Now this data happens to be alike in terms of layout. 12 That's not a requirement for some of the things 13 we're going to be doing, 14 but for other things it will be. 15 I've got a sheet called Totals here, 16 and what I'd like to do 17 is get the total for California here. 18 Now, jumping over to California, 19 we'll see the total here is in cell G8 20 and the totals for the other three states are the same. 21 Part of the reason we might be doing this too 22 is we're imagining this model might be growing. 23…

Contents