TOTAL BOX AT BOTTOM OF WORKSHEET

  • Thread starter Thread starter KENNETH
  • Start date Start date
K

KENNETH

I AM USING EXCEL 2000. AT THE BOTTOM OF THE WORKSHEET I
ONCE HAD A BOX THAT KEPT A RUNNING CALCULATION OF A
COLUMN OF NUMBERS AS I WAS ENTERING THEM.

I LOST THIS BOX. HOW DO I GET IT BACK

THANK YOU

KENNETH
 
Please refrain from caps, it's considered shouting and rude..
Right click in the statusbar and select Sum

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Hi Kenneth,

Not sure what you had before. Was the box with the SUM
in the same column. Did the box remain in the same position
on the screen. Were you just entering numbers in one column.

A1: 'Numbers
A2: 43
A3: 45
A5: 46
A6: ready for your entry
A7: =SUM(OFFSET(A$1,1,0):OFFSET(A7,-1,0))

put a border around cell A7 and make it bold
As you enter a number into the cell above the formula
it will insert an empty row above the total.

To install right click on the sheet tab, view code,
insert the following subroutine. If you didn't have macros before
you will now. The following is an change event macro
http://www.mvps.org/dmcritchie/excel/event.htm

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo recover
If Not HasFormula(Target.Offset(1, 0)) Then Exit Sub
Application.EnableEvents = False 'should be part of Change macro
Target.Offset(1).EntireRow.Insert
Target.EntireRow.Copy Target.Offset(1).EntireRow
Target.Offset(1).EntireRow.SpecialCells(xlConstants).ClearContents
recover:
Application.EnableEvents = True 'should be part of Change macro
End Sub

Please don't post all caps, it is rude (considered shouting), more to
the point it is hard to read. Learned one thing -- I downloaded a free
notepad replacement "xint" and it does a lousy job of converting to
sentence case, in fact it completely failed. But there is no reason that
we should have to translate from ENGLISH text just to read it.


I Am Using Excel 2000. At The Bottom Of The Worksheet I
once Had A Box That Kept A Running Calculation Of A
column Of Numbers As I Was Entering Them.

i Lost This Box. How Do I Get It Back

thank You

kenneth
 
You could use the SUM function in a cell, to total the numbers. For
example, if the numbers are in cells C2:C50

Select a blank cell, a few rows down from the last number, e.g. cell C60

Click on the AutoSum button in the toolbar. There's a picture here:
http://data.georgetown.edu/training/images/excel11.gif

Press the Enter key, and the total will appear in the cell
 
Back
Top