Excel ?


  1. Posts : 7,128
    Windows 10 Pro Insider
       #1

    Excel ?


    I'm trying to learn how to setup a spreadsheet in Excel and need a little help. This is my first attempt at making a spreadsheet. In this example how do I setup this spreadsheet so that I can keep a running total of columns C,D and E in column F if I keep adding new lines. If I'm doing it wrong any suggestions are welcome.

    Excel ?-ex-1.jpg
      My Computers


  2. Posts : 5,184
    64bit Win 10 Pro ver 21H2
       #2

    Hi Winuser,

    One suggestion, move the Total cell to the left so that it is beneath the Sub Total column. When you insert a new row (in your example you would be inserting at row 5) and then add your new numbers they will automatically be added in to the Total.

    Cheers,
    Phil
      My Computers


  3. Posts : 17,347
    Windows 11 Pro
       #3

    Oops, just checked. It is required to move the total to the left under the subtotal column. Also, the equation for the sum should be:

    =sum(E2:E4)

    The colon means sum everything from E2 to E4. When you add lines before the total line, the E4 should increase automatically to reflect the added lines.
      My Computer


  4. Posts : 7,128
    Windows 10 Pro Insider
    Thread Starter
       #4

    Thanks, I think I got it now. I'll play around with it some more and try different formulas so I can learn more about making spreadsheets.
      My Computers


  5. Posts : 7,128
    Windows 10 Pro Insider
    Thread Starter
       #5

    I've been playing around with my example spreadsheet and have it pretty much working the way I want. Thanks again for the help. I do have one more question though. Is there any way to have new entries auto fill? Right now I'm using copy and paste to enter new lines.
      My Computers


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 10:16.
Find Us




Windows 10 Forums