课程: Excel: Advanced Formulas and Functions

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Writing 3D formulas

Writing 3D formulas

课程: Excel: Advanced Formulas and Functions

开始一个月试用 购买团队方案

Writing 3D formulas

“

- [Instructor] 3-D formulas, they can simplify your life, immensely, if everything is set up right, and let's take a look at that. We want to make an overview tab, and that's where we are right now, and we've got these other five tabs. Let's look at 'em. Trip one, we've got gas, that word in B2 and then the amount that was spent on gas in C2, right? Gas, lodging, destination, days. Go to the trip two tab, same order, everything starts in cell B2. Good. Trip four and then trip five. Right, let's go back to the overview. Now it is time. No more waiting. 3-D formula, I want a total of the number of days equals sum open parentheses, go to trip one. I'm going to hold down the shift key and go to five. Okay and I want the number of days. I'm going to select C5, enter. 43 total days. So look at that formula. So we are doing a sum of cell C5, and then we look at trip one colon trip five. So we've got everything…

内容