View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] 1404ottawa@gmail.com is offline
external usenet poster
 
Posts: 6
Default Add up cell from sheet 1 to show on sheet 2

I want to total the value on sheet 1 col j1 + v1 + z1 to show on sheet 2
Is there a better way then putting this code on sheet 2:
+sheet1!j1+sheet1!v1+sheet1!z1
Much appreciated and thanks
PCOR