I have a workbook with 7 sheets. sheet 1 is a summary and sheet 2 to sheet 6
are detail.  The detail sheets have 6 sections in seven columns. Each section
is summed.At the moment I use a formula like this, =sum(first:lastD5) which
works. However if a row is added in any of the ...

I need a formula to sum A1:50 even if there are blank cells within that
range.  
For example, A1:25 has numeric data , but A26:50 is blank.  I want A:51 to
sum the entire range of A1:50.  How can I do this without having the #VALUE!

Column A and B of Sheet1 has the following data entered:
Sheet1 A1=Joe , B1=5
Sheet1 A2=Joe , B2=5
Sheet1 A3=Pat , B3=2

In column Q        column v           column y
Install                 3/28/08             ________
I want a formula to tell me whenever it is an install returns the date for
me of 3 3 days not counting the weekend.

I made a validation list and I want the value to pop up automatically.
I have 2 worksheets Sheet 1 and 2.
In worksheet 2 has names  and chart for prices.
I made a validation list from worksheet 2.  Defined a name of Animals.

In a range of cells, I have negative and positive numbers. How can I obtain,
in another cell, the value from my range that is negative AND nearest to
zero, and, in another cell, the positive number AND nearest to zero ? Example

Is there a way to hide or unhide rows and colums with a one-click feature
like the plus or minus sign that opens folders in a directory?

I have set up a template composed of various tabs, with financial data.
I need to alert users when they make a mistake, and to show them where is
the error to correct it.
Your input will be greatly appreciated.

When working with my spreadsheet, I'm unable to tab to the next cell.  Ex: I
enter info into a cell in column B, then hit the Tab key and it goes over to
column Q.  How can I fix my tabs so that it only tabs to the next column
cell?

SHEET1                                    SHEET2          
         A                    B                        A                    
  B
1     JOBID           MATERIAL           1  JOBID              MATERIAL

I need to evaluate the value in every other column of a row and determine if
it equates to 1,2,3,4,5,6,7,8,9,10 or 11. Each row has a player followed by
each event entered. If the player placed 1 through 11th place, these values
are in the row under each event in every other ...

how to round up integer values or real numbers to nearest tens e.g 214 to
210, 375 t0 380, 576 to 580 etc.

I want to change the format of the number in the cell based on a condition.
It seems that this function is limited to font, border and patterns.
Any suggestion?

I am trying to write a formula that will look at a column of data and return
the 1st, 2nd, and 3rd largest values. My major issue is that the values are
text. Example:
Term Reasons

My formula is:-  =SUMIF('INPUT PAGE - FLYING TIMES'!$D$4:$D$23,D3,'INPUT
PAGE - FLYING TIMES'!$H$4:$J$23)
D4 to D23 is the part of my data which I'm looking for the answer in D3
(aeroplane type).