Write a formula to total cumulative sales

Here are the steps to follow for this lesson:

  1. 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.”
  2. In cell C2, the formula is =SUM(B$2:B2)
  3. Notice the $ in the cell reference on the left side of the range = SUM(B$2…
  4. 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.”
  5. 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.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Speak Your Mind

*