From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Calculating year-to-date totals

Calculating year-to-date totals

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Calculating year-to-date totals

“

- In this worksheet called "YTD and Percent Increase," we're going to put in some formulas in row five here that calculate our YTD profits. A relatively simple formula, although one that can be a little tricky, and one that brings out the idea of cell references and how we work with them in Excel. In cell B5, our YTD profit so far is simply the same as the number we see above it. We could type a 20 here, and that might look correct for now, but the profit above it is actually a calculation showing sales and overhead difference. What if those numbers get changed? For example, we find out that maybe the sales number is 125, or the overhead is 125. We have a negative possibly here. What would happen then to the 20 that we just typed in here? It would stay the same. It would be incorrect. What we really want here for January, and January only, is for this always to be equal to the cell above it. As we're looking ahead toward February, we don't want that kind of a formula there. In…

Contents