Please help,
I need a formula for data validation that accept only "Yes" and "No"
values. Thanks.

Column CX contains entries that either begin with a "B" or "O".  I need to
count the number of cells whose contents begin with "B", and count the number
of cells whose contents begin with "O".
I wrote the following formula, and even saved it as an array formula, but I

Wasn’t sure what to put in as the subject.
Sheet 1 is my compiled data sheet. I have 12 other sheets with each
representing that months data. Sheet 1 is linked to each months sheet picking
up all the totals for that month and putting them in a table.

i have a worksheet like this:
column      c                  d            e            f
row 3     date             number   amount  
row 4    08/31/2006     13610      294.96     @dsum($data,"amount",number=d4)

I have a spreadsheet that has column A with project type and column B with
the status.  I need to count all projects of a certain type in column A that
do not have a status = Cancelled in column B.  The formulas as in another
worksheet.

Hi, I'm a bit rusty with this formula, which i have entered as an array and
have forgotten what i have done wrong;
My formula =IF('Purchase Ledger'!F:F=Creditors!B5,SUMIF('Purchase
Ledger'!D:D,Creditors!D3,'Purchase Ledger'!H:H),"")

In the office 2003 version an automatic getpivotdata formula is created when
setting a formula outside the pivot table.this makes it impossible to copy
the formula to other cells as all data becomes fixed.
how can I turn to my old formula setting mode?

Another Excel user states that this equation works on his computer
=SUMPRODUCT(IF(C10:C21<1099.41-F10:F21,C10:C21,1099.41-F10:F21),M10:M21)
However, when I formula audit - it gives me a value error on the first
c10:c20.

Column C has numeric values
Column F has numeric values
Column M has numeric values
What I would like to do somthing like the following:

I am struggling with finding a simple solution to this and I am not sure
if it is a function option or a programming option. In one worksheet
(Sheet A) as an example there could be two columns as below
Column A     Column B

I have a spreadsheet I've created that pulls information from one worksheet
to another and then runs several calculations on the data.  I want to be able
to post this on our intranet and allow users to look up their own
information, but do not want them to be able to make or save ...

The name field is in the following format:   Abbott, Susan H.
I would like to break it out into three seperate columns like below.
Last Name    First Name    Middle Initial
Abbott          Susan           H.

can someone pls explain how to change text in an existing excel workbook to
capitalsas in upper case text   thank you

I have a worksheet that has in column A a unique identifier. And then
for each of those idenitifers, an X in a column under a month.
    A    B    C    D
1        Nov    Dec    Jan

I need to find a formula that counts the number of cells in a column that has
data (text, &/or number), but the kicker is I need that number to change when
I use a autofilters.