On Sunday, November 4, 2012 6:31:54 AM UTC-8, wrote:
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

Try this:

Select J1, V1, & Z1 and name the three cells Data. On sheet two =SUM(Data).

HTH
Regards,
Howard