I have a list of times.  The column is formated for "Time 13:00" format and
it is calculated from two other fields.  The calculation to create this time
is correct and the format is correct.  
I want to be able to count the # of times that a time is listed between two

A    B    C    D      E
1    $0.01    1200    $12.00       0.0002
2    0.03    120000    $3,600.00       0.8889
3    0.45    100    $45.00       0.0006

I would like to get the data,the number of cells in column H of sheet2
with  value "open" in them, into one of the cell of  sheet1. I tried
to use
COUNTIF(SHEET2!H:H,"open") ..but it is giving error.

I have a workbook with about 100 sheets; they are all formatted the same as
far as rows, columns, etc. The data in the cells is different.
I would like to copy a range of rows based on the contents of a cell on the
worksheet.

I have an Excel 2002 SP3 Worksheet that extends to cell J:210.  This uses
data validation in slightly less than a third of the cells and sums the
validated data in approx 17 rows.  This creates a 288 KB file which is slow
to open and save on my  WIN XP Home Pentium 4 CPU 3.00GHz, ...

is there a way to express this formula below in a more compact way?
=CEILING(3*(SUM(MID(A1,1,1),MID(A1,3,1),MID(A1,5,1),MID(A1,7,1),MID(A1,9,1),MID(A1,11,1)))+SUM(MID(A1,2,1),MID(A1,4,1),MID(A1,6,1),MID(A1,8,1),MID(A1,10,1)),10)-(3*(SUM(MID(A1,1,1),MID(A1,3,1),MID(A1,5,1),MID(A1,7 ...

I am having trouble finding the regression function in this new version of
excel.  In the older version, I'd click on tools, then statistical analysis,
then on regression. I can't seem to find this same function.  Does anyone
know where to find it.

The keyboard shortcut for format painter in Excel 2003 doesn't work.

"To copy formatting, select the text, control, or other object with
the attributes you want to copy, and then press CTRL+SHIFT+C. To apply

I'm a new Excel user.  How do I add the value 1.5 to each cell in a column?

Is there an easy way to automatically format the contents of the cell
in any given column so that the content (text and numbers) are
enclosed in parentheses?
So, for example, 'random info' becomes ('random info')?

I have about 100 addresses in column A that correspnd to 100 addresses of
960 in column B but they aren't in the same rows right now.  And some rows
in column C have entries.
B    A    w

As a teacher we tried a new data analysis tool this year in my school
which worked really well... except for the fact that it meant manually
filling in a table.
I'm sure there must be a more efficient electronic way of doing it, but

I'm trying to use Microsoft Query (Office 2003 SP2) and Oracle 9i but
it is not working for two reasons:
1. The table's and column's names on Oracle DB are case-sensitive.
Error: "Can't access table TABLE1"

I would like my workbook to prompt the user for the "type" of a "form" to add
to the workbook, and then run a funtion which creates that type of a
worksheet.
In thinking about this, I have a question......

I am trying to calculate the total hours attended when I type in the
hours for the day. For example: 7:30 am is in Time In and 4:00 pm is
in Time Out Column. Now I need to get the total hours, which would be
8.5 hours or 8 1/2 hours. How do I do this?  Thank you in advance.