Transfering cells from multiple worksheets to formula

  • Thread starter Thread starter orlando
  • Start date Start date
O

orlando

Man, I gotta get refreshed on these things, sorry :( ...

Ok here is the scenario I am at now.... one excel file, multipl
workbooks.... how do I plus the data from the 3-4 other worksheets int
the main worksheet ? The math would be simple, I just need to add the
:(.

thanks again
 
Add two dummy sheets(empty sheets)with the name start as the first sheet
and one with the name end as the last sheet of your workbook.
this are empty sheets!!!

And use this formula

=SUM(start:end!A1)


Or this for sum the cell a1 in sheet week1,week2 and week3

=SUMPRODUCT(SUMIF(INDIRECT("'week"&{1,2,3}&"'!A1"),"<>0"))
 
Hi, this should work for you:
In the cell you want the sum in, type =Sum( then click on
the cell containing the first number. Then hold Shift,
click on the sheet label of the last sheet containing a
value you want to pick up, release the Shift key, and
press Enter. The sheet labels will turn white until you
press Enter, meaning that they're all in a "group". Any
values in the same cell you clicked at the beginning will
be picked up from any of the sheets in the group and added
together. I hope I explained this well.
 
Back
Top