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

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

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

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

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

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