How can I get a vertical lookup or sumIF formula to check multiple tab
for a given value?
Or - is there a way to specify the tab?  For instance, put "Tab A" o
"Tab B" in Cell A1, and have the lookup formula reference the value o

I need to find the time spent on a call ticket from:
7/07/06 3:30 p.m to 7/09/06 1:30 p.m.
Now, the problem is that I don't want the total days and hours.  I need to
know how much time was spent on this call ticket that was opened on 7/07 at

Help!
Range("A2:A57") may contain values from "A-K"
Range("B2:B57") may contain values M, T, W, R, F for the days of the week.
Based on those ranges I need to sum Range("D2:D57") where both criterias are

I've got a list of around 300 dates Format e.g 01/07/2006 for differen
years. Also some entries have ' in front of them to make them text
I want to count the number of dates in say A2 to A300 (may have blanks
and then count the how many in current year 2006.

I have a forumula that calculates total time.  The results are shown in a
time format (66:30:00).  How can we convert this to a decimal (66.5 hours)?  
Thank you for your help.
Michele

I am working on a spreadsheet and want the highest number in a row to be
highlighted.  Can someone tell me how to format this to work automatically.

Is there a way to create some sort of masking sheet over a current data sheet
that, when I re-input data, can tell me if there is a discrepancy between the
two values.  For example, on Data Sheet 1, I have the value 98765, and when
re-entering the data, I mistype 11234, Excel can ...

XL97
How can I concatenate multiple adjacent cells?
In Help it states that the Concatenate function works as
*=Concatenate(text1,text2...)* but only up to a max of 30.

Some cells often have the upper left corner colored in, in green.  Just the
corner.
I thought that meant the cell contained a formula, or used info from another
cell, etc.  But in the workbook I'm writing now, many cells have this, while

I need to extract a number from a text string. For example, Cryo Technician
$100.00. I want to extract the $100 rate and use it in another function,
i.e., Rate x hours.
I hope I made myself clear. Thanks in advance.

We export information from our ERP system on how long it takes to do a
certain process to a part.  The format is automatically a percentage of an
hour.  For example, to run a part through a lathe takes 0.50 which is 30
minutes.  Each part goes through different procedures and has ...

Presently, I consolidate data from 60 different files, each consisting of
about 9 sheets. Right now, we have to wait until all data is completed before
we consolidate. I was attempting to set it up by creating links to source
data so as data is entered, it automatically adds up. ...

i have a worksheet naming table_p_source with two columns, resource
query string value and page source.
Another worksheet naming, main_spread_sheet containing several columns,
but two columns are identical to table_p_source. One is the resouce

I am using SUMPRODUCT to count mulitple criteria in different columns. It has
worked up to this point, but I am now getting a VALUE!error and am not sure
why.
Here is the scenario: 2 columns

I am trying to write a function that counts the the cells within a range that
do not include a certain phrase.