Bob Phillips said: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 said: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
reno said: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 said: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 said: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
Bob Phillips said: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 said: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 said: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)
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
reno said: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 said: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 said: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
:
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)
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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.