For example, we want to add the best two values
A B C D E
1 7 9 4 2  ---> it will add 7 and 9
Cheers.

I have a cell with a constant named X. How can I want to change
this name to N and automatically have all other cells that had previously
referred to X now refer to N?
Excel 97

I would like to learn how to take outcomes of weekend football games & assign
them a value of 1 point for each correct location.  I have 10 players in this
office pool & there are 32 teams palying on any given Sunday, that 16 games.  
After I input their selection under each ...

I have this from surfing here and it not work.  What I have is column A
with headings, and what I copy into this would look something like this
for example....
( Used | to show cells)

I  had this before, but it didn't work weel! I may have not made it clear.
Range C5:C29 containes either letter C or letter M.
Range D5:D29 containes either letter M or letter F
line 5    C    F

In 23 days time I am off around the world for 10 years.  I have a pal
TX and have found that I can use excel spread sheets.  I already have
budget set in MS ACCESS that is accessable online, but I would like
budget in Excel so I can keep up to date as we travel around.

Excel 2002 SP3
Win XP HE SP1
*Follow-up group is: microsoft.public.excel*  *only reply to:
microsoft.public.excel*

I have a cell (E11) that has calculated the hours worked
'D11-C11(D11>C11)'. If that amount is greater than 5.5 hours (which it
usually is), I need to subtract a one half hour meal period from the
total.  I have tried '=IF(D11-C11>="5:30",D11-C11-"0:30",D11-C11)' but

I have 2 Files (File1.xls and File2.xls). Both files have 3 worksheets. How
do I create hyperlink from File1 to File2's Sheet2 worksheet?
Hope you might help.

I'm trying to divide one column by another column to give me another column
of awnsers as in B1/C1=D1, B2/C2=D2 etc... Is this possible?
Thanks

I have a series of client account numbers that range from 001-999.  I
first imported the client information from Timeslips which where we
keep client information into an Excel spreadsheet.  What I need to now
do is create a macro or a query that will tell me what numbers are not

I'm using Excel 2003 and when I save a file as a CSV it does not ad the
text delimeter. I get
Smith,John A
Instead of "Smith","John A"

Sheet 1 contains the raw data. Sales and cost of sales for customers.
Sheet 2 contains the pivot table that summarizes the data in sheet 1.
In Sheet 3(a further summary of the Pivot Table), I would like to put in the customer name and extract the related sales and cost of sales ...

I'm stumped.
I have a column that I'm trying to sum up. The column looks like this
             A
1     11:59:37

I need certain words in my scedules to be bold.  I dont want to have to go
through all my charts and select these individual words & i would like to
have these specific words just become bold as i type them in the future.
Please help.