Row 28 is workcenter names (L1, L2, B1)
Rows 29 through 105 are production cases for each workcenter by calendar day
I want to lookup L1 in row 28 and the sum the first 7 rows under L1 so i get
a total # produced for L1 for the first 7 days. Then i want the first 14

Hi, I have the following 2 formulae and i have been desperately trying to
make them work but the dont!
I am looking up the value of column D in 1 worksheet to look across 10
different sheets (which are all named) and then return the results as "1,0"

I have a spreadsheet that has a list of employees’ names in column A.  I use
F5 “Go To” to locate an individual by name.  I would like to leave the name
in the cell, but I would like to locate the individual by their Employee ID
number.  When I try to name the cell with a number ...

Dear Sir,
I have two tables or blocks.
Price                                      Nos
a  b   c  d                         d  e  f  a  c  b

I need a cell that is calculating the percent delta RT to be conditionaly
formatted if the value is out of range.  one range I am looking for is  <= +-
1.0%.
Thank you

I like to create formula to lookup data two rows below
Ex:
A1=Hyperlink(sheet2 part nr1)
A2=Hyperlink(sheet2 part nr2)

I have a relatively simple problem, but finding it complex to solve,
i'm entering start and finish times in in 24hr format (some going over
2400) and i need to manipulate these times to find,
a) total hours for a job (ie start 1055 end 0130  =  2:35)

I have several numbers highlighted in Excel. When I look to the lower right
hand section of the Excel Window, I can see the sum of those numbers. If I
right click the sum, I can change to the maximum, the minimum, the average
and so forth. There are times it would be useful to ...

I am tryed to put together some formulas to work the average time taken for
this below information but i have got myself all muddled up and I bet the
solution is fairly straightforward I want to work out the average time
between the firstapproved date and the actual start date to ...

not sure how to even approach this, what I have is a table in access that I
only want the last record to lookup or import into excel from access is this
possible?
Thanks in advance

I would like to calculate the mode for service start dates within an order
for a large number of orders. The orders contain a variable number of line
items where each line item contains a start date.
How may I apply "mode" and have the calculation restart for each new order

I have two worksheets that I need to automatically change the case to Upper
regardless of how it was typed in the first place.
In one worksheet, the range is Column C and in the second worksheet, the
range is Column B.

At least that's what we THINK we need help with. A co-worker has been working
really hard on this and has previously posted, but she’s stumped.  Here's our
situation -
We need a spreadsheet for tracking bonuses.  There will be 7 columns - date,

HELP…Would welcome help from experience formula users.  I’m attempting to
raise a list of orders required, dependent on data from primary worksheet.
Info follows:
(BOOK 1)  Row 1 is headers - Col A: Site Ref, Col B: Site Id, Col C:

I have the following formula:
=SUMIF(Data!$T$6:Data!$T$20000,"Long
Term",(Data!BE$6:Data!BE$20000/sum(Data!BE$6:Data!BE$20000)))
I am having a problem in making this work.  I want it to look in cells