I am using a sumif function to sum data in a different file.
If I use the path to external data as x:\share\dir\file\cell..cell it works
OK, but if I replace x: with network name such as
\\nas\share\dir\file\cell.cell, it returns error.

I have a spread sheet that has training certificate dates. Some are pass
dates, others are expiry dates.
I need to be able to flag them up 2 months prior to their expiry dates.
Can anyone help?

Hi i have a very large excel file which won't open for me - I have
tried to open it about 7 times but it refuses to open - I cannot get
into the file to turn calculation off and as it stands its about 30mb.
thanks

I have a table with data entered by date.  I want to sort the data by month.  
If I merely format the date to show month-year, the data is still only sorted
by date.  How do I convert a date entered as 09/15/06 to a month displayed as
Sept 06?

You are going to kill me, but it keeps returning zero when the total should
be $14.27.  Could you take a look at it again.....pretty please?
"Bob Umlas" wrote:

Does anyone know why the following custom validation formula does NOT
allow
the user to accept zero (0) as a valid replacement for the target
cell?:

I AM TRYING TO CREATE A LIST OF 10 RANDOM SAMPLES WITH TWO DIGIT NUMBERS FROM
A 5 X 5 MATRIX THAT I ALREADY CREATED. HOW DO I INPUT THE COLUMN, ROW AND THE
STARTING NUMBER>

I am working  with a table where I need to sort and subtotal by employee and
department.  I'm trying to figure out a way to either use subtotal or a pivot
table to do this.  With the pivot table, I get the data sorted correctly but
the name doesn't carry to each line.  If I ...

I set a SUMIF Function in a cell as :
=SUMIF(B2:B222, "Jack", C2:N222).
However, the return to the cell is 0. I think this SUMIF Function is not
working because the figures in cells C2:N222 are created by another worksheet

how I can edit array functions
thank

I have a set of 5 tables with values, by month (12 columns, but single row),
one each for 5 fiscal years, or 60 columns (cells), total (on worksheet A).
I also have a dropdown validation box (seperate cell) from which the
worksheet user can select one of the 5 fiscal years (one ...

ok so in column B I have "Market" (Chicago, new york, etc.)
In column C I have Total Sales
The goals for total sales are different for each market.  How do I Underline
the values in all cells that exceed a certain value depending on the market.

i am interested in performing a task that will describe in terms of
pseudo-code:
if i were doing this with a programming language, then i would write a
program that takes in a matrix as a parameter. this would be an n x 3

I am currently trying to convert hours to minutes or numbers to
minutes...  for example if I take 1127 -812, I get either 315 general
number or 3:15 in time format (if all numbers are in time format)... if
I go this way, I would like to convert the time to show minutes or 105

I have a workbook with several worksheets.  After entering data into selected
sheets it needs to feed into a letter built in one of the worksheets.  A
userform on the letter sheet is used to pick which worksheet the data should
pull from.  I have visual basic code written so it ...