Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel SUM problem

CivilServant · 2005-03-14 21:55:01

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…

14-03-2005 10:55PM

#1

CivilServant

Registered Users, Registered Users 2 Posts: 2,005 ✭✭✭

Join Date: June 2002

Posts: 1860

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!

0

Comments

#2 15-03-2005 12:38AM

Gosh

Registered Users, Registered Users 2 Posts: 684 ✭✭✭

Join Date: October 2004

Posts: 655

Check you have Automatic Calculation set on

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

0