I have a series of identical worksheets from First! to Last!. Is it possible
to sum the product of cell A1 and cell B1 in each of the workbooks? If so,
how? Thanks

I should add that I am trying to avoid setting up a product (ie C1=A1*B1) in
individual worksheets.

"woodcockmolely" wrote:

I have a series of identical worksheets from First! to Last!. Is it possible
to sum the product of cell A1 and cell B1 in each of the workbooks? If so,
how? Thanks

Put the sheet names in cells M1:M3 (or further) and use

=SUMPRODUCT(N(INDIRECT(M1:M3&"!A1")),N(INDIRECT(M1 :M3&"!B1")))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"woodcockmolely" wrote in message
...
I should add that I am trying to avoid setting up a product (ie C1=A1*B1)
in
individual worksheets.

"woodcockmolely" wrote:

I have a series of identical worksheets from First! to Last!. Is it
possible
to sum the product of cell A1 and cell B1 in each of the workbooks? If
so,
how? Thanks

Many thanks.
This fixes the cell references, but I found that if I used

=SUMPRODUCT(N(INDIRECT($M$1:$M$3&"!"&TEXT(ADDRESS( ROW(A1),COLUMN(A1),4),0))),N(INDIRECT(($M$1:$M$3&" !B1"))))

then I could copy the formula to cells A2,A3 etc with automatic change of
the reference to cell A1 leaving B1 unchanged.

"Bob Phillips" wrote:

Put the sheet names in cells M1:M3 (or further) and use

=SUMPRODUCT(N(INDIRECT(M1:M3&"!A1")),N(INDIRECT(M1 :M3&"!B1")))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"woodcockmolely" wrote in message
...
I should add that I am trying to avoid setting up a product (ie C1=A1*B1)
in
individual worksheets.

"woodcockmolely" wrote:

I have a series of identical worksheets from First! to Last!. Is it
possible
to sum the product of cell A1 and cell B1 in each of the workbooks? If
so,
how? Thanks