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

  2. philc43's Avatar
    Posts : 2,029
    64bit Win 10 Pro ver 1607 Build 14393.693
       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.

    Cheers,
    Phil
      My System SpecsSystem 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:

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


 

Related Threads
Solved EXCEL sort sequence in Software and Apps
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...
As per title, because there's a dollar sign in the figure. Win7 did this very well... ffs
Excel - read only bug in General Support
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...
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...
Solved Excel Preview in Software and Apps
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 02:46.
Find Us
Twitter Facebook Google+ Ten Forums iOS App Ten Forums Android App



Windows 10 Forums