Sumproduct across multiple worksheets
 

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

Sumproduct across multiple worksheets
 

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

Sumproduct across multiple worksheets
 

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

Sumproduct across multiple worksheets
 

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