Windows 10: Excel ? Solved

  1.    30 Jan 2016 #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.

    Click image for larger version. 

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

  2. Posts : 3,438
    64bit Win 10 Pro ver 1803 Build 17134.81 and W10 Insider Build 17677
       30 Jan 2016 #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.

      My ComputersSystem Spec

  3.    30 Jan 2016 #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:


    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 ComputerSystem Spec

  4.    30 Jan 2016 #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 ComputerSystem Spec

  5.    31 Jan 2016 #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 ComputerSystem Spec


Related Threads
Solved EXCEL sort sequence in Microsoft Office and 365
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...
Can't paste into Calculator from Excel in Microsoft Office and 365
As per title, because there's a dollar sign in the figure. Win7 did this very well... ffs
Excel - read only bug in Microsoft Office and 365
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...
Mailmerge from excel to in Microsoft Office and 365
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 Is it even possible? There doesn't appear to be anything on the web at all that I can...
Solved Excel Preview in Microsoft Office and 365
Can anyone tell me how to Save As? I don't see the option when I have edited a spreadsheet.
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 17:08.
Find Us