I'm trying to develop a formula to calculate a sales team incentive bonus.  A
bonus amount is calculated based on sales made, but then is adjusted 3 months
later based on the criteria below.  
Less than 50% of sales still on the books 0% payable

The results of the following formula is 0 when column G has values in it.
=SUM(IF($B$6:$B$65536="John Doe",IF($B$6:$B$65536="Jane
Dane",IF($B$6:$B$65536="Jack Dark",IF($G$6:$G$65536<>"",0,1)))))
Can someone please show me what I am missing or don't need in the formula in

I opened a new worksheet while still working on saved one.  Did not realise
that when I saved it saved it over the previous one.  Is there any way to
retreive it, or has it gone forever.  I am just learning and need help.

I need to save my file in a csv format. When the file is reopenned, some of
the numbers are in a date format and others are in exponential format. How
can I format the number to keep the numbers from changing format. I have
tried various formats before savint the file. In this ...

I have a pivot table that I would like to have a calculated field  that fids
the avereage by evaluating the the count of schools / total sales.
the count of shools is created when placed in the data but my question is it
possible to then use that data in a formula that is ...

I have attempted again to get the text import feature of MS Excel 2007 to
work using a really long (10,402,255 lines) ascii format text data files with
two columns of fixed width fields.  Despite the updates to the Excel 2007
program since I first tried this, the implementation ...

I have list of times in hh:mm format from cell A1 to A730
e.g. 9:30, 13:00, 13:32, 12:12 etc...
How do I put number of minutes passed from 9:00AM
i.e. if A1 has 9:30 then B1 must display 30, if A2 has 14:12 then B2

I have created a worksheet template that is saved and  used monthly to
summarize data exported from another db. The cell references in the template
that correlate to the imported data never change nor do the names of the
imported worksheets.

How do I create an autofilter for columns that are not next each other?
Example, COLUMN A and COLUMN C may be the only columns that are important for
my purpose on a spread-sheet.

I have a sheet with the name of:  June 2006
In an other sheet called (Report) in the same workbook in cell C25
I have the following formula:   ='June 2006'!E$160*'June 2006'!$D$1+'June
2006'!F$160

what I need to do is have a formula where if (F23-D23) is greater than
(K23-I23), use (F23-D23),...
IF (F23-D23) is less than (K23-I23), Use (K23-I23)... If they are
equal use (F23-D23)

I want to place "1" in column 8 in every row in my range named
"LegendList". How do I do this?
I tried:
LegendList(, 8) = "1"

I'm trying to create a formula dynamically by concatenating a number
of cells into a string which represents the my desired formula,
however, I can't get excel to accept the result as a formula.  Instead
it displays it as a string.

I have an automatic refresh from an imported source. I've set the profile so
the refresh is done when the excel file is opened. But an alert message with
2 selections is presented. One to do the refresh and the other to skip the
refresh. I want the refresh to stay automatic and ...

I am having troubles with formatting cells in EXCEL 2003.
I have a column of many hundreds of  rows lthat contain data like
this:
01Jan12