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 there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel SUM problem

  • 14-03-2005 9: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