| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT: Can you use this and sum the values from multiple colu | Excel Discussion (Misc queries) | |||
| how to i add the first six values of of a row when in various colu | Excel Worksheet Functions | |||
| Coverting data from some columns to rows (but not the primary colu | Excel Discussion (Misc queries) | |||
| Looking to check a cell on ws1 against data in ws2 that is 7 colu. | Excel Worksheet Functions | |||
| How do I sum a range after 2 different conditions are met (2 colu. | Excel Discussion (Misc queries) | |||
Linear Mode
