Thanks Thanks:  0
Likes Likes:  3
Needs Pictures Needs Pictures:  0
Picture(s) thanks Picture(s) thanks:  0
Results 1 to 6 of 6
  1. 12th November 2021, 05:00 PM #1
    smidsy
    smidsy is offline 21 with 26 years experience
    Join Date
    May 2004
    Location
    Sunshine Coast Queensland
    Age
    53
    Posts
    1,401

    Default Quick & Dirty Excel

    Hey Guys,
    Aside from one job twenty years ago where I was entering data in to pre-created forms I have never used Excel - I've just never had need for it.

    I now have a task where I have 41 (and growing) lines of numerical data, with two numbers on each line - so three columns, one for the item description and two columns of numbers.
    Without going through a massive learning curve is it possible to have this data in an Excel sheet so I can update individual lines while Excel keeps a running a total of the two columns.
    Basically what I am looking for is a way to not have to add up two lots of 41 numbers all the time.
    Is there a website or video which will show me how?
    I'm using Excel 2007 so there's no help from MS.
    Cheers
    Smidsy
    Reply With Quote Reply With Quote
  2. 12th November 2021 05:00 PM # ADS
    Google Adsense Advertisement
    Join Date
    Always
    Location
    Advertising world
    Age
    2010
    Posts
    Many





     
  3. 12th November 2021, 05:11 PM #2
    BobL
    BobL is online now .
    Join Date
    Feb 2006
    Location
    Perth
    Posts
    27,792

    Default

    =SUM(startcol/startrow:endcol/endrow)

    Lets say the first column starts at B3 and ends at B44.
    At anywhere but usually at B45 you'd enter
    =SUM(b3:b44)

    Lets say the second column starts at C3 and ends at c44.
    At anywhere but usually at C45 you enter
    =SUM(b3:b44)
    Reply With Quote Reply With Quote
  4. 12th November 2021, 05:45 PM #3
    Chris Parks
    Chris Parks is offline GOLD MEMBER
    Join Date
    Jun 2005
    Location
    Helensburgh
    Posts
    7,696

    Default

    There are many videos of the type you need on youtube. Seeing someone doing it on video is less painful than learning via any other method.
    CHRIS
    Reply With Quote Reply With Quote
  5. 12th November 2021, 07:15 PM #4
    aldav
    aldav is offline GOLD MEMBER
    Join Date
    May 2011
    Location
    Albury
    Posts
    3,039

    Default

    Quote Originally Posted by BobL View Post
    =SUM(startcol/startrow:endcol/endrow)

    Lets say the first column starts at B3 and ends at B44.
    At anywhere but usually at B45 you'd enter
    =SUM(b3:b44)

    Lets say the second column starts at C3 and ends at c44.
    At anywhere but usually at C45 you enter
    =SUM(b3:b44)
    Should have concentrated more on not being first to answer Bob. Reminds me of my first effort making a box with the Leigh D4.
    Reply With Quote Reply With Quote
  6. 13th November 2021, 11:57 AM #5
    damian's Avatar
    damian
    damian is offline COO - Sawdust
    Join Date
    Nov 2007
    Location
    Mt Crosby, Brisbane
    Posts
    2,548

    Default

    If you are still having problems pm me your email. I'll build it for you. If you email me your numbers I'll put them in and all you'll have to do is add to them.

    The easiest way to do it is allocate the first 3 columns to your data.

    Next select a cell to the right and type =SUM(

    then select the whole column you want to add

    then close the bracket )

    hit return.

    This way as you add data later it will automatically be added to the total.

    Repeat for your other column.

    I just built it but can't put it on the forum. Message me an email and I'll send it to you. Took about 2 minutes, cos I'm blind...
    I'm just a startled bunny in the headlights of life. L.J. Young.
    We live in a free country. We have freedom of choice. You can choose to agree with me, or you can choose to be wrong.
    Wait! No one told you your government was a sitcom?
    Reply With Quote Reply With Quote
  7. 13th November 2021, 01:53 PM #6
    rwbuild's Avatar
    rwbuild
    rwbuild is offline GOLD MEMBER
    Join Date
    May 2012
    Location
    Woodstock (Cowra)
    Age
    74
    Posts
    3,381

    Default

    Also lock the sum formula cells and unlock data entry cells and protect the sheet
    The person who never made a mistake never made anything

    Cheers
    Ray
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Basement Workshop - Quick & Dirty
    By two40 in forum THE WORK BENCH
    Replies: 27
    Last Post: 9th August 2018, 10:03 AM
  2. Quick and dirty Blast Gate.
    By MandJ in forum DUST EXTRACTION
    Replies: 3
    Last Post: 22nd April 2017, 10:05 AM
  3. Quick& Dirty frames
    By journeyman Mick in forum WOODWORK PICS
    Replies: 11
    Last Post: 3rd October 2006, 11:33 AM
  4. Quick and dirty dovetailed box.
    By Driver in forum WOODWORK PICS
    Replies: 25
    Last Post: 27th July 2006, 10:54 AM
  5. Quick and dirty jointers
    By Arron in forum WOODWORK PICS
    Replies: 10
    Last Post: 26th April 2004, 08:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules