Software

Ask something
Discussion Locked

Excel summing columns

0 helpful
5 replies

by rmcpeake

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an excel spreadsheet.
I sum columns b1:b49 into b50
Columns in the range have other caculations to other cells in the spreadsheet. These work.
The grand total does not work for whatever cell calculations that reference other cells.
It islike I need a recalc function to get the grand total.
How do I fix this.

5 replies

by dklippert

If the spreadsheet is not automaticaly updating, go to Tools>Options and choose the Calculation tab. Make sure that Automatic is selected.
BTW F9 will manually re-calculate.

by dklippert

As I mentioned in me e-mail, one of your formulas is adding the numbers back in as fast as you remove them. There is no recalculation, because the totals are not changed.

This discussion is closed to new replies.