how I do to sum times.
ex.: 10:00 + 15:00 = 25:00 Hs.
Tks.

Customer Name      2000 sales   2001 Sales     2002 sales
Joe Smith           $200.00
Joe Smith                        $300.00
Joe Smith                                        $250.00

I'm trying to count then number of cells with data in them, however the
=countta and =countif don't seem to work as some of the cells are filled with
something unseen.  They arn't filled with spaces, and the cells that I am
counting have different text entries, so I can't use ...

I'd like to figure out a clever way to build a dynamic date heading row.  I
need to enter the first month (1st of the month) and have the following
columns all be the 1st of the subsequent month.   I know I can just add 31,
but that does't get me precisely to the 1st each time.  ...

I am trying to set up a leave time report for people to use.  The forma
is below:
Date                 Type or Leave               Hours Taken
07/01/2005               A                                   8

Is there something that I can type in the "return column" part of the formula
that will make the formula dynamic as I copy it to the right it will return
column 2, then 3 in the next column and 4 in the following column?

How can a numeric amount be displayed as words as would be shown on a check?
eg.  cell A1 = 53.67
      cell A2 = +A1
      result A2 = Fifty-three and 67/100 Dollars

Hi, I have a question. Instead of actually typing ====== or ------------ , is
there a function or formula that allows me display this sort of design on the
spreadsheet instead of manually having to type it in. Thanks
For example my spreadsheet looks like this:

I have one cell where i enter a date 8/30/2005 (which resides in A3).
And i need another cell to display a date range based on the above date.
The date range will always be the same number of days apart. For example the
date range will always be 2-7 days from the entered above date ...

16-SEPT-2005
Hi.
I am trying to sum an array (column)of numbers based on the contents of
another column via function SUMPRODUCT. It works fine for one column

I am using this formula:
=IF(C29+D29<2;2;C29+D29)
I would like to modify it so that if C29=0, the formula returns 0.
Thank you in advance.

i have two colums of increasing numbers.
the first time column b is greater than column a i want to put an arro
in the next column.
So far whatever i do it puts the arrow every time the b is greater tha

Hallo everybody!
Any idea if it´s possible to get more then 65500 cells out of excel or
is it impossible?
Sweden

Hello, I have a formula working where I am looking for a Match of one
item...I would like to add 2 more items that need to match.  Is there a way
to add multiple criteria to the match function?  Currently I have Match(C1,
F1:H1,0)  I now want to add another match citeria e.g.  ...

I am trying to figure out how write a macro for the following things t
happen:
_Column_1_        _-Column_2-_        _*Column_3*_    
word1                        -word2-