Blank row

  • Thread starter Thread starter excel2000
  • Start date Start date
E

excel2000

I'm entering numbers under a colum, I need the total sum of the colum;
But after I enter the last number and press enter it needs to skip with
a blank row or cell ? but allways adding the total sum.
After the 221 press ente, the cursor will go to the next cell below
to enter my next number but allways have that blank row or cell before
the total sum.

Thank you very much.
JA
ex:
123
222
111
221
---> Here is where I need the blank row allways
677 This is the total sum
 
Press enter twice?


: I'm entering numbers under a colum, I need the total sum of the colum;
: But after I enter the last number and press enter it needs to skip with
: a blank row or cell ? but allways adding the total sum.
: After the 221 press ente, the cursor will go to the next cell below
: to enter my next number but allways have that blank row or cell before
: the total sum.
:
: Thank you very much.
: JA
: ex:
: 123
: 222
: 111
: 221
: ---> Here is where I need the blank row allways
: 677 This is the total sum
:
:
:
: ------------------------------------------------
:
:
:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank row 1
Auto insert a row or cell 3
Macro sum 1
insert row when sum of values equals 100 3
sumif for a specific number of cells 2
Sum Formula with variable range 2
"Blank" cells showing unwanted data 4
Excel Sumproduct 0

Back
Top