Whether you deal with papers day-to-day or only occasionally need them, DocHub is here to assist you take full advantage of your document-based projects. This tool can set formula in requisition, facilitate user collaboration and create fillable forms and legally-binding eSignatures. And even better, everything is kept safe with the highest security standards.
With DocHub, you can get these features from any location and using any device.
- [Instructor] For many users, its not uncommon to write formulas in some worksheets that get data from other worksheets within the same workbook. Less common, but also needed at times are formulas in one workbook that need to get data from worksheets located in another workbook. Lets cover some of these features. In this workbook, linkage formulas weve got data for four different States. Now this data happens to be alike in terms of layout. Thats not a requirement for some of the things were gonna be doing, but for other things, it will be. Ive got a sheet called Totals here. And what Id like to do is get the total for California here. Now, jumping over to California, well see the total here is in cell G8, and the totals for the other three States are the same. Part of the reason we might be doing this too, is were imagining this model might be growing. Maybe were a major retailer, but we only have stores in these four States right now. Were gonna be expanding, and eventual
