Lookup a value in a row and the sum the corresponding rows in colu
 

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
days, then 28 days.
I am not having any luck getting anything to work. Workcenter may not be in
the same column every time and the dates will always change depending on the
time frame i use.
L1 L2 B1
11/26/07 500 600 250
11/27/07 500 500 500

Lookup a value in a row and the sum the corresponding rows in colu
 

Maybe something like this:

=SUM(OFFSET(A28,1,MATCH("L1",28:28,0)-1,n))

Where n = the number of rows to include in the sum.

--
Biff
Microsoft Excel MVP


"bjw" wrote in message
...
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
days, then 28 days.
I am not having any luck getting anything to work. Workcenter may not be
in
the same column every time and the dates will always change depending on
the
time frame i use.
L1 L2 B1
11/26/07 500 600 250
11/27/07 500 500 500

Lookup a value in a row and the sum the corresponding rows in
 

Thank you. That worked.

"T. Valko" wrote:

Maybe something like this:

=SUM(OFFSET(A28,1,MATCH("L1",28:28,0)-1,n))

Where n = the number of rows to include in the sum.

--
Biff
Microsoft Excel MVP


"bjw" wrote in message
...
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
days, then 28 days.
I am not having any luck getting anything to work. Workcenter may not be
in
the same column every time and the dates will always change depending on
the
time frame i use.
L1 L2 B1
11/26/07 500 600 250
11/27/07 500 500 500

Lookup a value in a row and the sum the corresponding rows in
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"bjw" wrote in message
...
Thank you. That worked.

"T. Valko" wrote:

Maybe something like this:

=SUM(OFFSET(A28,1,MATCH("L1",28:28,0)-1,n))

Where n = the number of rows to include in the sum.

--
Biff
Microsoft Excel MVP


"bjw" wrote in message
...
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
days, then 28 days.
I am not having any luck getting anything to work. Workcenter may not
be
in
the same column every time and the dates will always change depending
on
the
time frame i use.
L1 L2 B1
11/26/07 500 600 250
11/27/07 500 500 500