I am working with a time sheet, hours are from 6pm to 6am,
I used the fromula =MOD(B1-A1,1), now I am attempting to
add the cells together.
I put the formula in a third cell to total for the day but

I am having a problem getting correct totals of a column. I put '1' in the cell when a visit is due. All I want to do is total the number of visits due for a given month. I have used =SUM(O1:O101), I get the total '65', when it is acutally 101.
I also used =COUNT(O1:101) and I ...

I'm new at this, and I posted on an old string, so I
thought it might get buried, so I'm pasting my question
again here. If my old post isn't likely to get buried, I
apologize. Please let me know if you can help me here.

Just to reiterate what I am trying to do.  I want to count (not sum)th
number of profits for each source and the number of losses for eac
source.  Below is a small table that I tried in excel.
Harlon, JE:  I tried again by entering values for the array. Stil

I have a spreadsheet with 20 columns, each containing various types of data. Column A is Date Received. Column S is Date Returned. Am trying, unsuccessfully, by using advanced filter, to have the sheet display all records where date received is 7 days or more before "todays" date ...

I am looking for a function to calculate this numbers.
  col.A
1     -5
2     -24

I am trying to copy a formula from one sell to several other cells.
I want to add up all the cells in a column with the total at the botto
in d51, I have pressed auto sum for this single cell and included al
the cells that I want d2:d49 but when I try to copy the formula t

I am looking for a formual to calculate the number of whole numbers between a positive and negative numbers
  -4 and 16 =2
   5 and 12 =
   -22 and -8 = 1

I remember seeing somewhere, that when you open excel, it can go right to
the workbook you use the most. How can I do this with 2000?
                   Thanks
                    Rusty

Excel 2000 / Dutch
I have a spreadsheet, in witch B2 to AW2 can be filled with "x" or left
blank.
On B1 I'd like to put an "x" if any of those collumns is filled with an "x"

I am having continuing problems with the following:
I have a spreadsheet which lists project status. One of
the columns shows the installation subcontractor.
I want to have a drop down box where you select the

Any one know where I can find a tutorial on learning how to setup a user
form.
I bought two book's on excel but they are not much help with user form's.
                          Thanks

I am trying to extract values from a numerical data base for a specifie
subtotal. E.g two columns of database.
Col. A  Col.B
xx         25

Why is Excel automatically rounding up the total of a column of numbers?

Is there any way to lookup multiple answers to a lookup formula.  Normally, Excel will stop at the first match it finds and return that as the answer when, in fact, there may be more than one answer.  I want to find the other matches as well and list them separately.
Here's an ...