I have a simple excel table, in one of the fields that is called "filled"
the answer is either (yes) or (no), I simply want to count how many "yes" and
how many "no" are there in that column, which function to use for that.

I have several areas in my worksheet that I need to protect th
formula's, my spreadsheet also has auto filter therefore I can'
protect the worksheet or the filter won't work.
The end user of this worksheet will also need to have the ablitity t

I have entered this formula into a cell formatted as General.  It will not
show the date/time.  It is showing the text of the formula.
Please help!

Is there a way to unlock a spreadsheet if I don't have the password?

Lewis Clark got my formula half-way there this morning. Thanks Lewis! If I
had been a bit more precise, I bet he would have told me the rest of what I
need to know. When my value goes over 30 cubic centimeters (I know this is
not exact but is approx. 1 oz.), I want to use a ...

I'm using Excel 2000 and trying to use the datedif function. I've formated 2
columns as date m/dd/yyyy and left the formula column general I'm entering
dates
A1: 1/1/2002

Can someone tell if it is possible to secure a pivot table? (Aside from
locking down the cells.) If you also know how to secure the Dsum fuction
please let me know.
Thank you,

Is it possible to unhide a selection of rows when you click on a cell.
For example, if I had a cell that said "Fruit", and I clicked it, could
it unhide 5 rows below that contained specifc types of fruit (ie apple,
pear, orange etc).

Using Excel 2003, I have been given a worksheet with names and addresses in
this format:
A1 contains "John Smith"
A2 contains "123 Main Street

I have a some values in three columns that basically snake from Day 1 to Day
45 and I will like to add them up starting from Day 1 going to a particular
Day that adds up to a value in another field.
Day1    $100,000.00     Day21        Day41   

I have a nested IF function question. I have 9 columns. The first column (A)
is the name of an employee. The 2nd (B) -8th (H) columns are days of the
week. The 9th column is for tallying PTO hours (paid time off).
For example - Normally there is an S (swing shift) in each cell of ...

In cell A1 I have YWCA. In cell A2 I have 012345 and (101) 452 1234.
These are respectively an account name, account number and phon
number.
As the end result I'd like to have YWCA in column A. The account numbe

would like to convert a column that holds the name of a month
(January, February, etc) into a number (1, 2). Is there an easy way to
do this, you can't do enough if statemnts to do that. any suggestions?

how do I convert a julian gregorian date code into a regular date.  I have a
julian gregorian (1582) date code that I want to convert into a regular
month/day/year code.  How do I do this?  Is there a formula for this?  Here
is a sample date code: 2453523.

I am trying to create a formula for which I need to calculate a discount
percentage based on supplier spend.  For example, a supplier may receive a
discount of .25% based on spend between $1.00 and $100,000.00, .31% based on
spend between $ 100,001.00 and $ 150,000.00 and a .38% ...