I have been trying to use the countif function to count the number of times a
"Y" response occurs in a specific cell  in 15 different worksheets that are
all in one workbook. ...  I have tried        
=SUM(COUNTIF('1:15'!B51,{"Y","N"})  but I keep on getting  a "value error".  

I highlighted cells H3:S1002 and entere
*=AND(C3<>"",ISNUMBER(MATCH(C3&D3&E3,$C1:C2&$D$1:D2&$E1:E2,0)))* fo
Conditional Formatting but only the cell in Column H (instead of al
the cells in Columns H to S) is formatted where C, D and E match.  I

I'm setting up a formula to calculate hours of vacation based on a schedule
that increments by years of service.
I have the formula set up and working, with the one hitch that when there is
no date of joining entered, the formula enters the highest amount of vacation

I have created several workbooks in Excel that I no longer want to use I have
removed all the content but how do I remove the title?

Hola a todos
perdonar por esta pregunta, supongo que es algo trivial pero no soy capaz a
dar con ello
lo que quiero hacer es evitar que las macros que tengo creadas en VBA sean

Dear Friends,
I am trying to obtain the interpolated value from column B and return the
corresponding value from column A. There are two issues: I have repeated
numbers in column B which in this case I want the lowest value from column A

How can I set a tab order for cells in a worksheet so i can tab just to those
cells?
  Thanks

My Sheet:
A1= BOB
I want B1 to equal the value in A1 and additonal normal formatted text so it
would read "BOB's Total". I've searched all thru the help and cant find a

Alright,
This is my first post to the group!!
Here is what I have to get it started:
Worksheet(Manuf#) 26025 records (Product#, Description,Buyline, Manuf#)

I had a custom function that converts a hyperlink into a url from cell
to cell.
Function hyp2(r As Range) As String
hyp2 = r.Hyperlinks(1).Address

Hi, I have a Windows NT with Excel 97. I have a very simple csv file
containing:
1;2;3
When I open this test.csv file from File->Open in Excel it renders the

I am using both Powerpoint 2002 and Excel 2002.
I have an Excel spreadsheet with cell A1 - A10, filled with some text
and some number.
At the same time, in my Powerpoint, I have a text box on a slide.

I have a spreadsheet the contains different locations and students that
have either passed or failed a test.  Columns c2-c146 contain the name
of the students location and columns d2-d146 contain the words pass or
fail.  I can do a formula for counting the number a student at a

I coy/pasted data into Excell and when I try to sort it I get "This operation
requires merged sells to be identically sized".  I understadn the work around
in KB but how do I find which sells are merged?  

My daily roster worksheet is on a shared drive and accessed by up to 40
people on a 24 hour basis.
First one to open it automatically locks it and others ,including myself,
have 'read only' access. I need to edit this roster several times a day. Can