1.    30 Jan 2016 #1
    Join Date : Jun 2014
    Posts : 3,898
    Windows 10 Pro

    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.

    Click image for larger version. 

Name:	Ex 1.JPG 
Views:	2 
Size:	129.1 KB 
ID:	61579
      My System SpecsSystem Spec

  2.    30 Jan 2016 #2
    Join Date : Nov 2015
    Posts : 1,648
    64bit Win 10 Pro ver 1607 Build 14393.105

    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.

      My System SpecsSystem Spec

  3.    30 Jan 2016 #3
    Join Date : Jul 2015
    Posts : 5,884
    Windows 10 Pro

    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:


    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 System SpecsSystem Spec

  4.    30 Jan 2016 #4
    Join Date : Jun 2014
    Posts : 3,898
    Windows 10 Pro

    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 System SpecsSystem Spec

  5.    31 Jan 2016 #5
    Join Date : Jun 2014
    Posts : 3,898
    Windows 10 Pro

    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 System SpecsSystem Spec


Similar Threads
Thread Forum
Solved EXCEL sort sequence
Hi there I'm trying to create a list of Movies in my DB in alphabetical order with folders A,B,C etc. Is there a way to store for example "The Day the earth Stood Still - 1951" in D ignoring the word "THE" in the sort sequence if it's the...
Software and Apps
Can't paste into Calculator from Excel
As per title, because there's a dollar sign in the figure. Win7 did this very well... ffs
Software and Apps
Excel - read only bug
I have recently installed Windows 10 on my desktop. I now find that most of my files are "read only" I have tried to deactivate this in properties for the various folders but it does not work. Other than trying to copy every file that is currently...
General Support
Mailmerge from excel to Outlook.com?
Not sure if this is the right place for this, but, here goes............. I am trying to find how to mail merge email addresses from excel to Outlook.com. Is it even possible? There doesn't appear to be anything on the web at all that I can...
Software and Apps
Solved Excel Preview
Can anyone tell me how to Save As? I don't see the option when I have edited a spreadsheet.
Software and Apps
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 00:17.
Find Us
Twitter Facebook Google+

Windows 10 Forums