Here are the steps to follow for this lesson:
- CHALLENGE: Write 1 formula in Column “C” to allow the range of values in Column “B” to expand by 1 cell each time the formula is copied down in Column “C.”
- In cell C2, the formula is =SUM(B$2:B2)
- Notice the $ in the cell reference on the left side of the range = SUM(B$2…
- The $ creates a “Mixed Cell” reference in the formula. This allows the range of cells in our formula to expand when we copy the formula down in Column “C.”
- Learn how to clear the “Green Triangle” Smart Tags in a range of cells.
Find the video lesson that you want – Index to all Excel Topics
News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.
Link to this post!
Speak Your Mind