At least I think that's what I need to do.
Our contractors' commission on parts is 40% if they purchased the part
themselves, and 30% if the office provided the part. The way it's set up now
is the tech types "y" if they purchased the part, and "n" if it came from the

For example,
Sheet 1 is data base as below.
name     group    team
------     ------     ------

here is my function:
=sumproduct((C:C="Epoxy") * (D:D="Straight") * (E:E))
as you've already guessed, I get #Value!.  I don't know up front how many
rows to include, so I included the entire column.  What can I do to my

I am using a spreadsheet with phone numbers in it and need to cross the
number out but leave it visible.  How do I do this.

I assume SUMPRODUCT is what I want.
In sheeta, I have to columns of interest:
A2:A127 is text data created by IF statements.  An example of A2 would be
"0-30", meaning to say "0-30 days".  B2:B127 is a list of last names, also

I have a Loan Amortization Schedule project, but I don't know how to set up
the formulas. Can you help me out please.

Formula help:
Would it be possible to get a highest of some cells and but instead of
retaining the value get the value of adjacent cell.  For example, I
have numbers in cells C1 and C2 I also have Dates in Cell B1 and B2

I have a spreadsheet with 30 rows I hide 20 that are not in order and I want
to copy and paste data from another spreadsheet only in the visible cells.
But when I copy and paste excel paste from the cell I select and continues
pasting also at the hidden cells so I loose the order ...

I need to put a title to the top of each worksheet in Excel 2003. I can not
use the copy command, and the file>page setup>sheets>row thing is not
working!

Does anyone know where I can find a good write-up on Pivot Tables.
I'm not sure how or why they are used nor do I know how to set it up.
Thanks for your help.
Tom

I need to return data on one spreadsheet that is two rows above, and 10
columns accross, from the data that I want to base the search on.  I intended
to use a combination of a lookup and an offset command, but have so far been
unable.  

I would like to use the advanced filter to return all dates greater than
April 1, 2007 or are null.  I cannot seem to incorporate the two together.
Any help would be appreciated
Thanks

I have a work sheet which has multiple confidential employee information and
want to create a search in a 2nd sheet where employee can look only the
records with his employee ID.
Example:

Is it possable to restrict cells to only allow 2 carectors or 2 numbers in
each cell ?
Thanks in advance

I am creating a database using Excel 2003 and want to be able to have users
tick a box, how do I do this?