How can I get auto sum of column when new figures are added

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 18 Jul 2006 16:19 GMT

I have put in formula to total a column of figures, it has empty cells for
new items to be entered as they occur. It used to total in new items
automatically, now it will not total in new items. It is a Monthly
spreadsheet. I used" create a copy "to make blank copies to use for following
months. I made changes to existing sheets as I needed to by using CTRL key
and clicked on each future month. this may be why it will not total as new
figures are added.

Reply to this Message

Special-K - 18 Jul 2006 16:55 GMT

Depends how you set it up.

If you have the totals on row 1, ie =SUM(A2:A100) and when adding a ro
put the cursor on row 2 and select Insert a row the formula will chang
automatically to allow for the new line.

You could equally have the totals on say row 101 but theyll keep movin
down the spreadsheet as you add a row then you gotta navigate down t
the totals.

Or store the totals on a different spreadshee

--
Special-

Reply to this Message

Gord Dibben - 18 Jul 2006 17:21 GMT

Dave

Is calculation on Automatic under Tools>Options>Calculation?

OR are the new values entered being treated as text values?

Format all as General then in an adjacent column enter =ISNUMBER(cellref)

If real numbers, TRUE will be returned.

If not numbers, copy a blank cell and select the numbers and Paste
Special>Add>OK>Esc

Gord Dibben MS Excel MVP

>I have put in formula to total a column of figures, it has empty cells for
>new items to be entered as they occur. It used to total in new items
[quoted text clipped - 3 lines]
>and clicked on each future month. this may be why it will not total as new
>figures are added.

Reply to this Message

Rate this thread: