Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct?
i want to recap particular cells on 10 worksheets in the same workbook. i'd
start at D3, then D4...D52; such that on the recap sheet, D3 would be the sum of all D3 cells on sheets 1-10 [these are named sheets] thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct?
What sort of naming convention do you have for the sheets?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "reno" wrote in message ... i want to recap particular cells on 10 worksheets in the same workbook. i'd start at D3, then D4...D52; such that on the recap sheet, D3 would be the sum of all D3 cells on sheets 1-10 [these are named sheets] thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct?
the worksheets are like
BE-1026 BL-1991 these are store locations and store numbers, but I could change back to sheet1...10 so the formula would be eaiser to write and then change the sheets back ---done that in the past too "Bob Phillips" wrote: What sort of naming convention do you have for the sheets? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "reno" wrote in message ... i want to recap particular cells on 10 worksheets in the same workbook. i'd start at D3, then D4...D52; such that on the recap sheet, D3 would be the sum of all D3 cells on sheets 1-10 [these are named sheets] thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct?
No need to do that, it is less complex than I first though
Just use =SUM(BE-1026:BL-9999!$D3) where BL-999 is the name of the last sheet. If you will add more sheets later, maybe add two sheets, one named first and put it at the start, one named last and put it at the end, and have the data sheets (except recap) between these, then use =SUM(first:last!$D3) You could even hide first and last -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "reno" wrote in message ... the worksheets are like BE-1026 BL-1991 these are store locations and store numbers, but I could change back to sheet1...10 so the formula would be eaiser to write and then change the sheets back ---done that in the past too "Bob Phillips" wrote: What sort of naming convention do you have for the sheets? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "reno" wrote in message ... i want to recap particular cells on 10 worksheets in the same workbook. i'd start at D3, then D4...D52; such that on the recap sheet, D3 would be the sum of all D3 cells on sheets 1-10 [these are named sheets] thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct?
i'm getting #name error, don't you have to proceed the sheet name with
!sheet!BE-1026, or can shift-point to first and last in the formula? in htis case the BE-1026 is only used as a worksheet name within the workbook. thx "Bob Phillips" wrote: No need to do that, it is less complex than I first though Just use =SUM(BE-1026:BL-9999!$D3) where BL-999 is the name of the last sheet. If you will add more sheets later, maybe add two sheets, one named first and put it at the start, one named last and put it at the end, and have the data sheets (except recap) between these, then use =SUM(first:last!$D3) You could even hide first and last -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "reno" wrote in message ... the worksheets are like BE-1026 BL-1991 these are store locations and store numbers, but I could change back to sheet1...10 so the formula would be eaiser to write and then change the sheets back ---done that in the past too "Bob Phillips" wrote: What sort of naming convention do you have for the sheets? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "reno" wrote in message ... i want to recap particular cells on 10 worksheets in the same workbook. i'd start at D3, then D4...D52; such that on the recap sheet, D3 would be the sum of all D3 cells on sheets 1-10 [these are named sheets] thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct?
What are the sheets actually called?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "reno" wrote in message ... i'm getting #name error, don't you have to proceed the sheet name with !sheet!BE-1026, or can shift-point to first and last in the formula? in htis case the BE-1026 is only used as a worksheet name within the workbook. thx "Bob Phillips" wrote: No need to do that, it is less complex than I first though Just use =SUM(BE-1026:BL-9999!$D3) where BL-999 is the name of the last sheet. If you will add more sheets later, maybe add two sheets, one named first and put it at the start, one named last and put it at the end, and have the data sheets (except recap) between these, then use =SUM(first:last!$D3) You could even hide first and last -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "reno" wrote in message ... the worksheets are like BE-1026 BL-1991 these are store locations and store numbers, but I could change back to sheet1...10 so the formula would be eaiser to write and then change the sheets back ---done that in the past too "Bob Phillips" wrote: What sort of naming convention do you have for the sheets? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "reno" wrote in message ... i want to recap particular cells on 10 worksheets in the same workbook. i'd start at D3, then D4...D52; such that on the recap sheet, D3 would be the sum of all D3 cells on sheets 1-10 [these are named sheets] thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Help! With SUMPRODUCT | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions | |||
SUMPRODUCT Help | Excel Worksheet Functions |