View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default share/ link info between sheets

Say we have a table in Sheet1 from A1 thru D10. In Sheet2 we want the sum of
the first column in Sheet1. Use:

=SUM(Sheet1!A1:A10)

--
Gary''s Student - gsnu200742


"thapelo1" wrote:

I have created formulas is sheet 1. I want to create a table in sheet 2 using
totals from sheet 1. How do I work with formulas between sheets?