Working on Excel2000 I have a function that gives me headache.
The function is:
=SUMPRODUCT(($C$7:$C$10=B$1)*1,$D$7:$D$10,MMULT($F$7:$I$10,TRANSPOSE((F5:I5=$A2)*1)))
Broken down in pieces it gives

I have many CD's with files in excel and cannot open the
files.  The message is: "file format is not valid".  What
do I need to do to open these files in excel?
Thanks.

I am having difficulty with data that is both numeric and alpha in a spreadsheet.  I download the data from a peoplesoft query.  It is formatted as 'general' by the query.  The excel file is changing the format to scientific when I save the file.  I have tried changing the format ...

I thought that you could do something to a spreadsheet so
that cells would show the formula involved for all
formulas on a spreadsheet.
How do you do that?  

Look at this,these are the marks obtained by different
students,for instance.
Jim    76
Bob    76

If have got a problem and need to nest a function to achiev following:
I have got a database in my spreadsheet and values in square meters in the last column. My function should now sum up the sqm values if column A shows "customer1" and column B shows "product1".
In anather cell I ...

Dear friends,
I'm having problem in filter function. I've a excel file with 2466 rows in one sheet. After I've apply AutoFilter,  why I cannot see all the data that I have from the filter list?
Best regards,
Fion

I have 2 sheets, sheet 1 is full record list and sheet 2
is a fax cover that will be created based on sheet 1.
How can I do the following?
Input a number on sheet 2 (eg. cell A1) so that it will

Hi Excel experts,
Just wonder can we request Excel to return '0' instead of "#N/A" when
the database to lookup not found? To illustrate better, pls refer to
the enclosed example worksheet.

I am using Excel to create a simple time sheet.  When I
take the result of the deduction between time in and time
out, and multiply it by the hourly wage, I get a number
that does not correspond to the right number.

Oops...hit send on accident...anyway:
I've applied the "ACCOUNTING" format one column of cells,
but halfway down the column, the format is different.  It
is supposed to look like "$    -" when there is a zero

Just wonder if we can set preferred colour text to the text appearing
using If, Then, Else function? For example, a function having the
following :-
=if(A1="","Error","OK")

I import data into excel from an  .ap file and then do a
vlookup from another page to find that imported data. My
problem is that the .ap file I am importing from has the
data in a different form than I need it. I am dealing

Is there a way to make an input mask so that a date
entered in 1 column is something like mm/dd/yy? I have
used the format cell approach but it still allows me to
enter other tex. I want it so the only thing entered is

I'm trying to figure out how I can do a "Countif" formula
when comparing a column of dates with one particular date.
For example: 12/1/04; 11/27/04; 12/4/04 and comparing it
to 11/30/04. Countif date in set 1 is greater than