I would like to summarise my dive times (columan A) by depth (column B).
E.g. summed dive times for depths 0-9.9m, 10-19.9m, 20-29.9m, 30-39.9m,
40-49.9m, 50m-.
I cannot find similar syntax in the Function Help section.

I have my producers listed across the top of my spreedsheet, they are listed
by their producer number, and their pounds are listed below, sample below
220000     223300     456700      345400      675400
3300            4500         4501          2345        3456

Hi, is there a version of LINEST() for two independent and one dependent
variable for a function in three dimensions?

Can I use vlookup to find data in a named range?  I currently have a
list of locations in col A and monthly sales data in cols AP:BB.
(There's a heap of other data in the intervening cols.)  I have
included cols A and AP:BB in a range I have named "Sales_FY06".

Whenever I make cell 'A1' = '$A$2 and insert a line at 'A2', the value 'A1'
gives me is that of 'A3'.
I would like 'A1' to equal whatever number inserted into 'A2'.
I am using office excell 2003.

I received this formula from Ron in the past 3 weeks.  
=Index(offset(A:A,0,Match(I2,1:1,0)-1),Match(9.9999E+307,offset(A:A,0,Match(I2,1:1,0)-1)))
This formula works with I wanted to do, which was to caluclate my routes by
having a producer listed and then the program would give me ...

I am looking for some way to filter datas automatically based on user's input
in a dedicated cell.  For example, I got a list of values like below.  
Value
1

I want to create a formula that will refer to the cell I want by adding a
number to the cell reference, not to the contents of the cell.  For example,
lets say that the cell C11 holds a value of 22.  I want to add 4 to C11 to
get my formula to reference cell C15, I don't want it ...

I'm trying to copy and paste contents of a cell to another cell in order to
complete an entire column (about 300 rows).
The contents of the cell is a function which acts on data on two separate
worksheets.

Anybody able to help ?

I never tried to do anything like this before so here goes!  I am
trying to create a nested if then else statement.  What I have is 7
fields one of which I created the other 6 where exported data.  In the
6th field I have times in there that is subtracting a from fields B and

My macro automatically runs autofilter and filters data with every filter
criteria I have set and moves them to separate sheets. But I want the macro
to automatically identify all the filter criteria in a given column and
filter out the data in separate sheets. I tried my best to ...

ok...my current formula is *=COUNTIF('Input Page'!A2:A50000,"=Monday")*
i'd like to change it to check what day is in the field and then only
do the above formula if that day is within the past week.
so i need the *"=Monday"* section to be changed to read "(is equal to

I am using this code to send emails from an excel workbook.
Is there a way to add the "From" information.
'Sub Mail_ActiveSheet_Body()
   Dim OutApp As Outlook.Application

In the Help for DMIN Criteria portion it suggests using a Table.
Can I key the Criteria argument directly into the Criteria section of the
Function?