Results 1 to 10 of 10

Thread: Spreadsheet help

  1. #1
    Archbishop of Banterbury Coleman's Avatar
    Join Date
    Jul 2013
    Posts
    1,416
    Thanks
    117
    Thanked 148 Times in 117 Posts

    Spreadsheet help

    I haven't done spreadsheet work for a while. All i'm trying to do is get this: =SUM(C*/D*) to autofill for every line i.e. =SUM(C2/D2) =SUM(C3/D3) =SUM(C4/D4)

    What do i do. I'm using openoffice if that's of any help

  2. #2
    Administrator jt999's Avatar
    Join Date
    Jul 2013
    Location
    Eastbourne
    Drives
    Mercedes A Class AMG Line
    Posts
    3,639
    Thanks
    89
    Thanked 288 Times in 242 Posts
    I'm confused, what do you want it to do? If you have the formula you can just drag it across, or am I reading that wrong?

  3. #3
    'GLS' Member
    Join Date
    Jul 2013
    Posts
    333
    Thanks
    7
    Thanked 20 Times in 18 Posts
    What happens when you try the auto fill? Does it just copy without incrementing? Try filling in two / three of these, then highlight and drag for autofill

  4. #4
    Archbishop of Banterbury Coleman's Avatar
    Join Date
    Jul 2013
    Posts
    1,416
    Thanks
    117
    Thanked 148 Times in 117 Posts
    it copies without incrementing, whether it's just one cell filled with the formula or 3/4 of them.

  5. #5
    'GLS' Member
    Join Date
    Jul 2013
    Posts
    333
    Thanks
    7
    Thanked 20 Times in 18 Posts
    Have you tried turning if off and back on again?

    (I don't have open office so just **** about trying to get it to work)

  6. #6
    'GLS' Member
    Join Date
    Jul 2013
    Location
    Coventry
    Posts
    190
    Thanks
    10
    Thanked 17 Times in 15 Posts
    Put the formula in the first one i.e A3=A1/A2

    then one you pressed enter on the A3 cell drag the little sqaure in the right corner across to the cell where you want the formulas to stop

  7. #7
    'GLS' Member
    Join Date
    Jul 2013
    Location
    Coventry
    Posts
    190
    Thanks
    10
    Thanked 17 Times in 15 Posts
    Spreadsheet help-excel-explanation.jpg

    Example

  8. #8
    Archbishop of Banterbury Coleman's Avatar
    Join Date
    Jul 2013
    Posts
    1,416
    Thanks
    117
    Thanked 148 Times in 117 Posts
    It's now incremented correctly, but the value it's showing is the first box's total.

  9. #9
    'LS' Member
    Join Date
    Jul 2013
    Location
    Shropshire
    Posts
    64
    Thanks
    7
    Thanked 2 Times in 2 Posts
    I know excel, but not openoffice. But I think they work the same.

    If you want to get the SUM of a bunch of cells you should be using the colon not a slash. i.e. =SUM(B1:B12). This would add all the cells from B1 to B12 together and display it in the cell with the formulae in.

    SUM = Add
    / = Divide

    You are trying to tell it to add the two cells at the same time as divide.

    If you only want to add two cells together, you could just do =B1+C1, =B2+C2, etc
    SUM is usualy used when there are more than 2 cells being added together

    Once you are happy that the formulae works for one calculation, use KingoStarrs screenshot, and drag and drop the formulae down as far as you want the formulae to be used.
    By the sounds of things you want to drag the formulae down, and not across like KingoStarr has. But it works the same

  10. #10
    Archbishop of Banterbury Coleman's Avatar
    Join Date
    Jul 2013
    Posts
    1,416
    Thanks
    117
    Thanked 148 Times in 117 Posts
    Well, i went for a **** and when i cam back, it all worked as it should. Happy days, I really didn't want to manually input 1750 lines today. ****ty open office.

    Thanks all

Tags for this Thread

Posting Permissions

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