I am looking for a way of counting the amount of times "PASS" appear
in column B wether or not column A is filtered. I have trie
countif(B1:B10,"PASS") but when column A is filtered the total cel
counting "PASS" in column B still shows the overall total. I need it t

I have a user using Excel 2003 on Windows Xp pro.  When he opens an Excel
file the message "Excel cannot access the 'file name here'.  The document
maybe read-only or encrypted."  If I make him a power user the message does
not appear.  We do not want anyone to have install ...

I have created a macro that I would like to insert into an I
statement.
For example.
If cell A2 = 1, then I want the macro to run.

Is it possible to count a specific Conditional Format? For example: Any
missing data in a column range due to certain criteria I highlight the cell
in Red. What I would like to do is count those red cells and have a
"Missing" total at the bottom of the range.

XL2000, Windows NT 4
    I have two instances in a worksheet where I need a macro to
join several rows in column A.
    In the first instance, the first row I want to select

When I try to enter a whole number into a spreadsheet for example "99
enter" it appears as .999 in the cell.  There is no formula in the cel
- repeat no formula in the cell!  However when I enter 9.99 it appear
in the cell as 9.99 no problem!  This excel 2000 was working fine unti

I have a range of dated in a column and want to arrange them i
assending order. My problem is if that this range of data is linked t
another data input sheet whidh places a 0 in place of no data entry
When I use my sort macro it puts all 0 enteries on top.

I'd like to run a program that writes values from one
cell to another with a VBA program that is triggered by
the clock. I've completed this part but, since I use
active cells, you can't run another workbook without the

I would like to have some help on this
problem.
Here is a sample of the columns
  A         B             C           D

I am trying to sum the amounts in column c if they match the criteria i
colum f.
I can sum c if column f is a single criteria.  My problem is I wan
column c to sum if the criteria in column f is <>.

I am working with an excel worksheet with five columns (account, date
description, purchase order, and expense amount).   I want to summariz
from this worksheet all of the expenses by account.  
I know how to get the total expenses for each account from this list

Hi, can I import data from another Excel file into one main Excel file? My
problem is that in some of the different Excel files the data that I want to
import is in a different column...ie Customer/Address1/Address2/Postal Code
(main file)  /Address1/Address2/Postal Code/Customer ...

I am trying to get (blank) to stop appearing in cells that contain no data.
Can anyone help?

I have 2 questions.
1- How can I format a cell so it shows the number of hours and minutes in
the same format as time. (35:20) (right now, it turns it back to an hour
between 0 and 24 or it takes it as text)

I want to have the Excel standard toolbar available when a spreadsheet is
opened over a LAN with internet explorer. How do you make the toolbar
available? Thanks very much.