On more than one occasion, I have used autosum to add up a column of numbers
and the sum is one cent off.  I double check the answer with a calculator so
I'm sure of the problem.  Is there anyone who has encountered this problem?

Can someone help me shorten the following IF statement, or give me something
simpler that will work.  I have more conditions I'll need to add:
=if(w22=11,sum(o9:y9),if(w22=10,sum(p9:y9),if(w22=9,sum(q9:y9),if(w22=8,sum(r9:y9),if(w22=7,sum(s9:y9),if(w22=6,sum(t9:y9),if(w22=5,sum(u9 ...

I have a workbook with multiple worksheets ..  I have columns for date,
vendor, payment, balance .. and it is set up to subtract the payment from the
balance each time I make an entry.  I just had to add about 20 rows .. am I
going to have to manually go in and enter a formula ...

Version:Excel 2003
I am trying to reference the first and the last cell within a group of
cell with the same value.
Here is what I have:

This is probly a simple thing to do but I cant figure it out . . .
I have a coulumn that is full of dates and I want to count how many cells
fall within a certain range of dates.  For example :
A1 = 5/1/08

I have a data rage that column A is employee name, column B is date that the
employee worked, and Column C is the hours worked on that day. Their are
additional columns that calulate overtime. On a separate Sheet i have an
overveiw of this and other data. I want to do a sumif ...

I have a speadsheet I am working on and would like some cells to be
"formatted" so when the user enters a number it will only accept it one way.  
For example:
If the user enters the case number as 081234, the cell is currently

I have a list of names (most repaeted several times) in column A that act as
a diary of work completed.  I need excel to look at the names in column A and
then count / sum information found in another column.  I have tried Vlookups,
if and countifs but to no avail.  Any help ...

I have several long strings of text in which I would like to separate the
first sentance ending in ". " into another field. Which function would I need
to use. Any help would be greatly appreciated.
Example:

I copied EXCEL files on a CD from a desktop.  I now have six of them with an
.xls
extension, but about three more empty copies of each that I cannot get rid of.
Every time I log in a message at the bottom says I have six files ready to be

Please help.  
I want to evalue the returns of a series of investments as shown below.  
        2008          2009          2010             TOTAL    IR = 0.05
INCR Sales   $166,873     $813,114    $1,266,398   $2,246,385    

Can anyone think of a simple way to accomplish this:
Goal - use the Linest function to create a regression against a series
of dynamic ranges.
Example:

hello again,
i have two reference columns A & B
column A contains text, column B contains numbers
i also have another two columns C & D

How do I get Excel to display Jan instead of 1 - Nov instead of 11, etc.  as
the result for my = MONTH ( ) function?

Question1: How do I calculate the number of combinations in a 49 number 6
ball lottery where every combinations adds up to say: 138.  Sum total 279,
for instance, can only happen once.
Question2: How do I generate these results?