View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
woodcockmolely woodcockmolely is offline
external usenet poster
 
Posts: 3
Default 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