Excel Guides

Adding Up Tops and Bottoms in Excel

Adding up tops and bottoms in Excel can be a bit of a challenge, but it's definitely doable! Here's a step-by-step guide to help you get it done:

  1. First, open up Excel and create a new spreadsheet.
  2. Next, enter the data for your tops and bottoms into the spreadsheet. Be sure to include the prices for each item in separate columns.
  3. Now it's time to start adding up the totals. In the first empty column, type in "Total Price."
  4. In the cell directly below the header for "Total Price," begin by typing in the following formula: =SUM(
  5. Now, click on the cell containing the price of the first top item. This will add that cell's address to the formula.
  6. :
  7. Click on the cell containing the price of the last top item. This will complete the address range for all of the top items' prices.
  8. )
  9. Hit Enter to calculate the total price for all of the top items.


  10. ***Image 1***


    1. In the cell directly below the one containing the formula for adding up all of the top items' prices, type in "Total Price."


    2. ***Image 2***


        OR

        You could also use a shortcut to create this second "Total Price" label by copying and pasting (Ctrl + C then Ctrl + V) what you just typed in Image 2.

        Then, double click on the lower right hand corner of that cell until you see a small black square.

        Drag that black square down until it reaches the last row of your data.

        When you let go, all of those cells should now say "Total Price." See Image 3 below.


        ***Image 3***

        < br / > Now that we have our labels set up correctly, we can move on to actually adding up our prices! < br / > In Image 4, you'll notice that I've highlighted cells B4 through B8.< br / > These are my top items' prices.< br / > We're going to use these cells in our SUM function formula.< br / > So in Cell B9 (the one directly below my second "Total Price" label), I'm going to start by typing in an equal sign (=). Then I'm going to type SUM, open parenthesis, click on Cell B4, type in a colon (:), and click on Cell B8.< br / > Finally, I'm going to close my parenthesis and hit Enter.< br / > Doing this should give us our total price for all of our top items! See Image 5.< br / > If everything looks good so far and your total price is correct, we can move on.< br / > If not, go back and check your steps to make sure you didn't miss anything.< br / > Once you're ready to continue, let's move on to adding up our bottom items' prices! < br / > In Image 6, you'll notice that I've highlighted cells C4 through C8.< br / > These are my bottom items' prices.< br / > We're going to use these cells in our SUM function formula.< br / > So in Cell C9 (the one directly below my second "Total Price" label), I'm going to start by typing in an equal sign (=). Then I'm going to type SUM, open parenthesis, click on Cell C4, type in a colon (:), and click on Cell C8.< br / > Finally, I'm going to close my parenthesis and hit Enter.< br / >< img src = "https://i

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.