I'm running Excel 2003.  I have a list of values in one sheet (call it 1),
several worksheets of which each contains a unique status report and another
sheet (call it 2) that contains values from sheet 1 that also contains a
hyperlink to the unique status report sheet.  The ...

I've been using the sample spreadsheets from contexture.com. to do my
projects.  Helpful doesn't even come close.  However, the sample file
called ProductOrderList has a code that when you move over a cell in
column g, it automatically puts an x in the cell, which copies this row

I'm working off of two worksheets.
Worksheet 1 contains all the data.
Worksheets 2 has partial data.  
I need to use the data (in this case a part number) in cell A1 on worksheet

I have a spreadsheet with addition of several numbers in one cell.  How can I
display these numbers and print them instead of the final value?

I'm looking to create an excel sheet which when someone inputs a start
time eg: 09:00, time for lunch: 1 hour, and length of shift: 7 hours,
it throws up the time they are due to finish ie: 17:00 - I know this is
relatively straight forward to work out in your head, but we have a ...

Lets say I have some numbers in the range A1:A10 and I have to take a
sum of it in cell B1, I will use the formula =SUM(A1:A10).
My question is, is it possible to detect the last row of the range and
have a dynamic formula?

I have a spreadsheet created by someone else. Autofilter is on all columns,
and there is a row at the bottom called TOTAL which has SUBTOTAL values in
it. When I filter, the TOTAL row is always displayed, which is what I want,
but I cant really understand why it is always ...

I want to creat a formula to insert a statict time in a cell depending the
value from other cell.

I have a column that looks like this;
Direct Mail-Ltr
Direct Mail-Ltr
Direct Mail-Ltr

I cannot find a way to return (for instance) the distance in the 3rd column
of a distance table, for a whole series of "From" - "To" iternies in another
tabel. These "from"and "to" fields are text-values in 2 different columns.
For each combination, I want to test whether there ...

I have created an 'IF' statement which reads as follows
=IF('General Stock'!C2=1,'General Stock'!B2,"=if('General
Stock'!C3=1,'General Stock'!B3,=if('General Stock'!C4=1,'General
Stock'!B4,=if('General Stock'!C5=1,'General Stock'!B5,=if('General

I formatted the cells as Number and/or Currency, repaired, and reinstalled.  
If I enter an amount like five dollars, I have to enter the entire "5.00" or
it will show as ".05".  If I enter just " 5" it shows as .05 (five cents).  
In Excel 2000, I only had to enter "5" and the ...

How can I do a countif check where the value is a variable and held in
another cell?
i.e.
A1 = Average(E1:E70)

i came to a dead end and i need help
i have this table
cl-air     tl air    cl sea    cl A-sea  cl B-sea    truck    LTC
Truck

I often try to set up a countif or a sum if that is conditional on two or
more conditions.  For instance - I have Radio stations listed in one column,
flight dates in another column, number of contacts for each flight in another
column and appointments created from those contacts ...