Announcement

Collapse
No announcement yet.

Spreadsheet help

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new 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
    Originally posted by Vegas
    When I hit boost me fuel runs out

  • #2
    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?


    Comment


    • #3
      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

      Comment


      • #4
        it copies without incrementing, whether it's just one cell filled with the formula or 3/4 of them.
        Originally posted by Vegas
        When I hit boost me fuel runs out

        Comment


        • #5
          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)

          Comment


          • #6
            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
            .

            Comment


            • #7
              Click image for larger version

Name:	excel explanation.jpg
Views:	1
Size:	48.3 KB
ID:	109148

              Example
              .

              Comment


              • #8
                It's now incremented correctly, but the value it's showing is the first box's total.
                Originally posted by Vegas
                When I hit boost me fuel runs out

                Comment


                • #9
                  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

                  Comment


                  • #10
                    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
                    Originally posted by Vegas
                    When I hit boost me fuel runs out

                    Comment

                    Working...
                    X