i want my colleagues to mandatory fill in a cell before saving. is
this possible? (sorry for my poor english)
thanks
bta

Would like to calculate an average on an array based on a condition.
For example, if I do:
= SUM((Color="Red")*(Units))
I get the sum of all the units which are red....my arrays are Color

I'm trying to add numbers based on criteria from another cell.  So for
example, if D2 contains the value of KS then I want the values of cells AC2,
AD2, and AE2 added together.  I then need this do throughout the entire
worksheet to arrive at a total sum.   Any help or ...

I am wanting to set up a trend for inventory over the new 10 years.  Is there
a formula that will help me?  I have the current year inventory and the last
few years as well.

One of our users is getting the above error message everytime she opens Excel
2000.  She does work quite often on a document that has custom number
formats, however, this message is coming up when opening Excel versus opening
the document itself.  We've tried to repair Excel, but ...

I have a table with three columns; Date, Type and Day. The Day column was set
up by creating it from the date column (Format!Number!Custom!DDDD). There is
three years of data amounting to 22690 records. The Type column is for five
types of vehicles; car, pickup, van, suv and ...

I am working on a spreadsheet and need some help.  Is there any formula or
macro that can take into account a new sheet being added on a monthly basis?  
In short I need a worksheet that will link to the new worksheet on a monthly
basis without a lot of work.  Everything is in the ...

Thanks for the help, but I misstated my earlier question/example.  Here's
what I really want to accomplish.
On Sheet A, cells a1:cv100, I want to reference the values from Sheet B,
cells b2:b101. Is there an easy way to accomplish this?  On a related note,  

I currently have the following populated in a spreadsheet:
  A              B              C
1    Plan    Actual
2  Jan    $10.00     $10.00

Hi friends,
I fix a picture in sheet background.
After some text typing I want to print the sheet with the background.
But how to do I dont know.

I need to format one cell to have two formulas showing both answers as follows
" $25 / $35 "
I thoughthe formula (if simple) would look like this-
="$"(A3*A5) "/" "$"(A4*A5)

I am making a spreadsheet where I am puting a bunch of hyperlinks on the
sheet.  But every time I go to add a new one, I have to go through the whole
menu to get to what I want.  Is there a shortcut to doing this?

I was wondering if someone could help me.
I have 5 projects with different set of revenues.
Project        Rev        Cost        Profit margin
P1        50000        X1        Y

32,000 lines of data on my 'Master Sheet':
LOT#          # PASSES              LOCATION
====================================
(plus many more columns of stuff I'm not worried about now)

I have a report export that has data on multiple worksheets. Each location
has a separate worksheet. I want to combine the information from each
worksheet into one master list. Each worksheet is formatted the same with the
same columns and column headings. The number of rows ...