Hi
I want to check condition of 3 columns in my sheet and then add the count of
column and also sum the values in that column
I am using this formula, but it does not work

In excel, how do I creat a static row at the top of my document, meaning when
I scrowl down, the headings of the colums remain at the top?

Is there a feature that switches Right-Clicking on and off?
Right-Click has suddenly stopped working in Excel 07 although works fine in
other Office 07 programs.
How do I get it to operate again?

I need to change the name of a downloaded file
Example: An outside system creates a file "account.txt", on my system, every
morning and cannot tolerate having an existing file with that name.  I would
like to change the name to "acct062507.txt" for the data gathered on the

CAn someone detect what I am doing wrong on the following formula:
=IF(F7>=40%<=70%,"17.3%",IF(F7>70%<=75%,"16.9%",IF(F7>=75%<=80%,"13.6%",IF(F7>=80%<=100%,"9.1%",0))))
Ideally if the ref cell (f7) has 83.2% I want 13.6% returned.
Thanks so much.

During the last install of Excel 2003 when I tried to open Excel 2007 files
Excel went out and found the convertor to open the file, this time it did
not. I find the file, but Excel 2003 still can not reconize the file. Can
someone help, please.

If a condition is true in a colum or series, I would like to grab a value in
another column and place it in a given cell in another tab.
Can anyone help with this?

Experts,
I have a range to copy and paste. The range to copy varies with a
variable value. While defining the target range, I just give reference
to first cell of the column where it has to start pasting.

Our Accountant asked me this question and what he says is that he wants to
stay in, for example, b12 in each sheet he has set up in his  workbook.  For
example, B12 is balance and each sheet is a different branch of the bank.  
Can anyone help?

Is there a way to insert a word or comment as part of a macro into a cell
using conditional formats?  For the cell in question, I have written an IF
statement that will enter a 1 when something is incorrect.  I've written that
formula to be =IF(A2<B2,1,"").  For cells with a 1 in ...

Is it possible to make a comment appear to the left of, below, or above a
cell instead of always to the right of a cell?
Thanks

I have a workbook for each day of the month of June. The name in each tab
will be each day of the month. I don;t want to have to rename each tab. I
should be able to let excel update the tabs. HOW?

Don't know why the cells are automatically highlighted when moving the cursor
without clicking the mouse.
When it happens, i try to close Excel program or select function keys, but
the computer doesn't response. And i have to close it by alt-ctr-del.

Say I have a spreadsheet with tons of formula, is there a way to
select (highlight) those that have the formula I specifiy? (say SUM,
AVERAGE, etc.  I wanna do FDS actually for factset).  Thanks.

thank you.