Sumproduct across multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
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.
 

Ask a Question

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.

Ask a Question

Similar Threads

3d References 7
How to sum one cell across workbook if nr of worksheets is variabl 2
Conditional Sum across WORKSHEET 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
COUNTIFS BETWEEN WORKSHEETS HELP 1
SUMif or SUMproduct across multiple worksheets? 1
Sumproduct across multiple worksheets 3
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1

Back
Top