12 Days Excel: Part 2

Excel Table Instructions

Part 2: Calculations with AutoSum

Follow these directions for calculating how expensive your 12 days can be.

Auto Sum

1. Begin by figuring out the sum of items each day. Place your cursor in B18. Click the Auto Sum Button (see image).
2. Dashed lines will appear where excel thinks you should look to figure out your some. You should click and hold while highlighting the appropriate areas in that column. When you let go, you sum should automatically be calculated.
3. Repeat this process and find the proper amount for "Item(s) each day" (B18 through M18).
4. File- Save
5. Now move to the "Number of Items". Click so your cursor is in cell N5. Use the Auto Sum button, and highlight days 1 through 12 in row 4. Repeat this process to find out how many number of items you have.
6. File- Save
7. Now we are going to calculate the " Total Costs ". Click your cursor in cell P5 and type the formula =N5*O5. Press return and your information should be automatically calculated. Repeat this formula for each item (Item #2's formula =N6*O6, etc.)