View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Adding one cell in Sheet 1 to another cell in Sheet 2

=(a3+Sheet2!a6)


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Web Office Support" escreveu:

How can I add cells across multiple sheets? I need to add A3 (Sheet 1) to A6
(Sheet 2) and have the total appear in A31 (Sheet 1).

Thanks!