Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back a page or two to re-sync the thread and this will then show latest posts. Thanks, Mike.

Excel SUM problem

  • 14-03-2005 10:55pm
    #1
    CivilServant
    Registered Users, Registered Users 2 Posts: 2,005 ✭✭✭


    Usually in excel it allows u use the SUM function to add up a bunch of numbers. And say you were adding up a lot of numbers one for each day of the week so the total would be at the bottom of each day (column).

    Now instead of doin the sum function at the bottom of each column, I would drag the first total across the entire week. And it would add up all the other columns. That's fine.

    Now recently it's started f-ing up. I drag the total across the bottom of the columns and it doesn't add the figures up. It keep the orginal total from the first column. Also when I change figures above the total, it doesn't change the total on the fly anymore, I have to redo the SUM manually which is a total pain. What is goin on? It's really pissing me off. Help!


Comments

  • #2
    Gosh
    Registered Users, Registered Users 2 Posts: 683 ✭✭✭Gosh


    Check you have Automatic Calculation set on

    Tools > Options then select the Calculation Tab and set to Automatic


Advertisement