I am trying to calculate the mean of about 70 numbers, but excell does not
seem to be doing it, it apears that the max is 30#s. can some one please tell
me how to do this, and whether there is a different formula.
Thanks

I need to use the SumIF (and SumProduct) on a collection of summary row cells
that have sub-component data between them and are therefore discontinuous.  A
comma is used to separate these values in the formula, but a comma is also
used to separate the three components of the ...

Dear All
Some times what happens that computer get shut down while an excel/ms word
file kept opened. after I restart the computer, file opens as read only and
if I want to delete the file, it does not get deleted , or cant be moved to

I would like to find a way to pull values (mostly text) from an Excel 2003
spreadsheet and put them into a form in another worksheet.  I'd like to find
a way to change the information in the form by entering the client's name and
have the function pull the last entry for that ...

I have a .csv file that is supposed to be separated at the comma's into
columns.  How do I get the comma delimited feature to work?

Why does the "Autofit" feature for row heights not work with merged cells?  
Is there a way to get this to work.

When I apply the autofilter funtion, it does so accross all existing columns
of my worksheet. Is it possible to apply this functionality to only a few
selected columns, and how do I go about it ?
Kind regards

Hi I am using Excel 2000 and have filtered a list so my result shows for
example rows:  1  56   159   241   410 but when I copy and paste into a new
sheet I start in A1 to paste and the information goes into A1, A2, A3, A4,
A5.  Is there anyway that I can get the pasted ...

I got a row of data formated in xx-yy, where xx represents percentage
(number), - is delimiter from and yx definition as letter+number. (e.g.
55-A1, 60-V2...)
What I want to do is sum only first two xx values, if y equals A for

I have an Excel problem that I would like to discuss (and hopefully solve)
with some Pivot Table and Graph experts.
It involves getting data from a list into a PT, doing some tricky
calculations, then showing the PT in a graph.

I need to multiply the total number of items in my column Q (e.g. POD's
delivered) by the different tonnages in column L to get a total tonnage
result?  There are 186 rows. Any ideas please?

I have created a workbook with several worksheets and the formulas do not
calculate unless it is changed on the computer where the workbook was created.

I have a situation where a company has had one if its divisions closed
and all of their products need to be removed from the product listing in
Excel.
I need to remove about 150 products from the product listing which has over

hi, we have a column of american dates which is only formatted as text. we
need to convert to australian date format, but nothing works.
any suggestions would be great
thank you

Using Excel 2003
I want to combine a number of worksheets into one.  Like you can i do with
docs in Word to produce one document. Is there any other way of doing it
rather than copy and paste?