I would like to count how many cells only IF they contain a value
greater than 1.  Is this possible?

I am trying to use the vlookup and hlookup to "cross hair" a cell.  I have
used this combination before but I cannot remember the formula.  I have items
in the first column and a month identifier in the following columns.  So I am
trying to look up Beans in column A with the ...

My table looks like this:
ColA    ColB    ColC
SPY    2%    5%
QQQQ    9%    7%

I have two colums with dates in and I want to subtract one from the other so
so I can get hte dumber of days between the two, this is the east part. The
problem I have is when one of the colums is blank I want to use todays date
so I can avoid #VALUE! being returned, I been ...

I need to select two cells in two ranges that meet two criteria's from
another sheet in the spreadsheet, one criteria is todays date and the other
is the letter s or c
ie coulumn A row 1-2000, column B row 1-2000

I need to create an IF statement that returns false when encountered with
both blank cells and cells with text

Excel 2003. I have a call log with the date call was received in a range
named "Date_Message_Left" fomatted as mm/dd/yyyy, and the Region number in a
range called "Region".  The region values are only 1, 2, 3, 4, or 5.  I want
a summary of calls to each region that were received ...

I have the following formula:
=SUMIF(DST.txt!$A:$A,B4,DST.txt!$B:$B)
In my problem worksheet to resolves to 0.00. When I place this formula
in a new workbook it works fine. The cell is not set to text, it is

I am recording a simple macro to insert a new worksheet and copy the content
of the active worksheet to it. Using the macro recorder, it works fine the
first time, but if I try to use the same macro to copy the second sheet (the
one just created) to a third sheet, it still copies ...

I would like to add a comment that "floats" on the page and moves to stay in
view, no matter where I have scrolled on the page. If possible, I would like
to place it at a position that stays in that relative position on my viewing
screen.

I have a report that contains names,SSN's, and dates. I need to sort the
sheet by the last 2 of the SSN. Can this be done?

I'm protecting individual spreadsheets by locking certain cells and then
going to tools and doing protection and protect worksheet, but when I do
that, the autosum icon lightens and is inoperable.  I only want certain cells
protected and want to be able to use all the icons on ...

I have a ComboBox on a sheet that I made from the Forms tool box.  
If I choose an entry from the ComboBox drop down menu, how can a cell
formula use that data to find what is in a cell 5 columns away?
Any help will be most appreciated, thanks.

how do i get the letters back on top of the columns.  some how they have
changed to numbers like on the rows.
thanks,

I gave a user a protected worksheet with a range of unlocked cells. She
edited (typed into) one such unprotected cell. At some point she also saved
the file and at one point she also had to use an autorecovered version of the
file after her computer crashed. After saving, and ...