I looked through the previous questions and didn't seem to find one that fit
my situation.  
I have a simple formula that returns #DIV/0! when there is no data in the
fields E & F.  I tried to but zeros in e&f and it still doesn't work.

I would like a Formula that uses an Input cell (to accommodate changing
Numeric Criterion) Summing the Count of a Numeric Criterion in the LAST 5
Rows of a Dynamic Named Range "Data". Named Range "Data" spans 8 Columns and
many Rows.

Please let me know if there is a way to do this.  I need to set something up
in Excel to alert me when I am trying to schedule an employee in the
restaurant that is already scheduled for that same shift in the bar.  

I am trying to determine why my 'if' statement does not work.  Can anyone
detect the error.
I am a novice at this and would appreciate the guidance from an more
experienced user.

Hi - I would be really grateful if anybody knows a function to return the
formula contained in one cell to another cell as a text string?
Thanks

    A      B          C         D            E
1    3      6          9         12
2    5                  SAM
3    10

1.  One sheet (Sheet1) contains a valid list of task numbers in column A.
2.  Another sheet (Sheet2) contains a valid list of people's names in column
A.
3.  Another sheet (Sheet3) contains:

Good morning/afternoon to everyone
I would like calculate a balance.
Example:
$5000.00 in an account, subtracting different amounts

I have the following nested IF function in a worksheet that gets its
info from a cell on another sheet. This cell "H2" is linked to a
combobox on sheet 1.
=IF(VLOOKUP(Companies!H2,Companies!A2:F200,3,0)="",VLOOKUP(Companies!H2,Companies!A2:F200,4,0)&","&"

Can anyone help me, Im trying to create a data sheet, basically I need to
enter a height value, then I need it to look at the value entered for the
height and if its up to 350mm then it must add 35% to a second value, if its
up to 600mm then it must add 40% to a second value and ...

I have a spreadsheet used to track claims.  Case Managers are assigned the
cases based on the surname of the client.  For instance, Jane case manages
all clients with a surname between A and K and Jill manages all clients with
a surname between L and Z.

Is it possible to do a countif using the same cell reference for every
worksheet?
Like a Shorthand of doing
=COUNTIF(Sheet2!A1,1)+COUNTIF(Sheet3!A1,1)...+COUNTIF(Sheet15!A1,1)

Sorry, I originally posted this in wrong discussion group (programming).  I
would like to do this using existing Excel functions (non UDF).
Can anybody tell me how to do a conditional concatenate.   I have to columns
of data.  Column A has numbers: 1-5 (A2:A6).  Column B has ...

I am working in Excel 2003 SP1, and am using a VLookup function that has
worked beautifully until last friday.  My function references a named range
on a different sheet within the same workbook, but I am now getting error
messages for some lookups, and not others.