Adding one cell in Sheet 1 to another cell in Sheet 2

  • Thread starter Web Office Support
  • Start date
W

Web Office Support

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!
 
M

Marcelo

=(a3+Sheet2!a6)


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



"Web Office Support" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
add hyperlink using sheet names and cells(i,j) 3
IF ARRAY with multiple conditions. 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
External cell reference between two excel worksheets both in One Drive 0
Calculate end date and time 1
Shift Collate sheet 1-20 when printing entire workbook? 0
copy specific cells from sheets if the information is correct 3

Top