I want to put into a cell the total of all numbers above that cell in that
column.  I want to do this without specifying specific rows.  In this way,
if a row were added above the total, it would be included in the total
correctly.

Im trying to use an old spreadsheet that I have not used for a few months.
But when I go back to try and update the data, I am getting the #NAME? error
in the result cell. I have just tried to update an existing time by just 1
hour and it loses the result. The sum that is running ...

I am using this formula in a cell for data validation
=IF(C31="DIRECT BUSINESS",C34=0,C34<25)
If C31 = "DIRECT BUSINESS", I Can only enter 0 in C34. this bit works
fine.

I create worksheets in VBA, then delete them again and create them
again.
One worksheet always stays in my workbook, but when I create such a new
worksheet with add it appears the first in line. I want it to appear it

I have  a worksheet and i need data to be extracted. This Data is for
various countries and Years. The cell which i need to get extracted ona
new worksheet changes when i change the country and year  different
cells. There are 20 countries and data for 25 years. Now what i want to

I have been using Excel 2002 to track events.  There are about 950 rows and
15 columns.  As events are completed, I hide the rows so that I can see only
active events.  However, I occasionally need to unhide a row in order to see
some data.  Then I rehide it.  When I say "I", I ...

How can I freeze a row and a column at the same time using Excel 97? Thanks.

I am trying to double underline a range of cells so that the underline
fills the width of the cell.  I followed Excel Help instructions as
follows:  
-You can apply a different style of underline, such as a double

Hello everyone! I am trying to figure out a way to bring data from one
spreadsheet while ignoring empty cells, and listing that data onto
another sheet. The first sheet with the data has over 700 rows. The
sheet I want to bring the data to only has 40 rows. At most the first

Is there any way to transfer automatically the polynomial regression factors
(of a higher order) calculated in charting  to a spreadsheet without being
forced to copying them by hand, digit by digit?
TIA,

Recently I started getting the following visual basic error when I start up
Excel2000 "Compile error in hidden module:AutoExecNew".  I get the following
error when I close Excel "Compile error in hidden module:DistMon".  When I
click  "OK" the program continues and other than the ...

Greetings from Taupo New Zealand.:cool:
I am able to move from cell to cell with the keyboard but when I us
the mouse it highlights a number of cells and I am unable to get out o
excel.

How change a julian date to "normal" date ?
Tks advance,
Luis Felipe

Hi. I think I have just posted this question, but I can't find it now, so my
apologies.....
I need to start at number 1 and multiply it by 2 - then multiply that answer
by 2, then multiply that answer by 2 and carry on until I have done that  480

How can I conditionally format a cell based on the percentage value of
another cell rather than the value of its own cell?.  All values ar
Example, I wish to format "A1" based on the value of B1.  If B1 = -5% then
A1 would colour Amber, if B1 = -10% then A1 would colour Red, if B1 ...