It looks like you're enjoying TheCorsa.co.uk but haven't created an account yet. Why not take a minute to register for your free account now? As a member you get free access to the forums and posts plus the ability to post your own threads/messages, communicate directly with members and much more. Register Now!
Already a member? Log in at the top of this page to stop seeing this message.
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
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
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
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.
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.
Comment