In my workbook I have several worksheets. In cell B2 of every worksheet,
there is an average from the data in that worksheet. As this is a
template, some data is not entered yet, and some B2 cells show error
(div by 0). Now, I wanted to calculate the average from B2 cells of all

How can I do this please?
Chris

Thanks a lot

------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://forums.yourdomain.com.au/showthread.php?t=844016

Without duplicating the cell contents in the current spreadsheet (call
it Template), is there anyway to have a dropdown list of items
(starting in cell T38 and going down to T45) from another file
([Price_List.xls]License_Only!C2 to C whatever row which will change).

I have a series of 15 spreadsheets, all having the same column
structure.  They all have the same filename barring first two letters
which refer to a persons initials.  The 15 files are stored in the
same directory.  In that directory I'd like to create a sixteenth file

Hello, I was woundering if this is possible and if so how. I want to "Auto
send" an email to 4 people once a month and in this email it would include
the information from two sheets from my workbook. The first sheet is named
"Years Of Service" and in the email I need to include ...

In my Workbook I have many cells with data validation settings as follows:
Allowed data: List
Source: =INDIRECT(L9)
Now, I`d like to change the source formula to the following:

how do i turn auto fill off?

I want the cell format (meaning color of the cell) to change based upon the
text entered. I have used up the conditioal formatting. It only allows three
formats, and i require more. I am inquiring if this can be made into a
formula for a cell to have the color change upon certain ...

I am working on a spread sheet where I have to determined the amont if parts
made per hour. The formula I need is a 12 hour work day, minus the down time
minutes to = parts per hour made.

I am trying to save a workbook in csv format so that I can upload into
another program.
The problem I have is that when I view in notebook i have many trailing
commas which have to bemanually deleted.

I recently created a *relatively large file in excel 2007 and when I tried to
save it as a 97-2003 workbook I too was notified that data had been lost. The
difference being from what I have read here so far is that the alert message
I received informed me that anything after ...

I am trying to combine information in 2 different sheets. Sheet one has a
column with numbers and a column with titles. Sheet two has a column with the
same numbers and other information I would like to use. What I would like to
do is pull the title information from sheet 1 into ...

Please forgive the ignorant question but when I open an Excel 2007 document
all I see within the document is a blue screen and not data previously
created. Thanks for your help