How do I refer to chosen areas from multiplesheets to calculate a total?

D

dran

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

HI. I'm not simply trying to copy a single cell from one sheet to another, but AREAS of up to 50 cells in each sheet, with multiple sheets needing to add up to the total sheet. The total sheet also needs to be presented in the same manner as the others.

eg. I have 20 inventory sheets with "size" on the X axis and "product" on the Y axis. I need to compile all the info from all the sheets into a total without having to click every single cell and add "+" in between. Is there a way to program it?

Thanks for your time!
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

HI. I'm not simply trying to copy a single cell from one sheet to another,
but AREAS of up to 50 cells in each sheet, with multiple sheets needing to
add up to the total sheet. The total sheet also needs to be presented in the
same manner as the others.

eg. I have 20 inventory sheets with "size" on the X axis and "product" on the
Y axis. I need to compile all the info from all the sheets into a total
without having to click every single cell and add "+" in between. Is there a
way to program it?
Click to expand...

IF all the sheets are laid out the same, you can use Data/Consolidate...
 
Top