summing cells in different worksheet

  • Thread starter Thread starter Kirschbaum
  • Start date Start date
K

Kirschbaum

I am trying to add two cells from sheet1 into sheet2. I
can seem to get the right syntax to make this happen.
Can I sum cells from sheet1 into sheet2?

John
 
Hi

=SUM('Second sheet'!A2:A3)
or
=SUM('Second sheet'!A2,'Second sheet'!Q7)

When sheet names don't contain spaces, you can omit apostrophes
=SUM(SecondSheet!A2:A3)


Arvi Laanemets
 
Thank you! That worked perfectly
-----Original Message-----
Hi

=SUM('Second sheet'!A2:A3)
or
=SUM('Second sheet'!A2,'Second sheet'!Q7)

When sheet names don't contain spaces, you can omit apostrophes
=SUM(SecondSheet!A2:A3)


Arvi Laanemets





.
Click to expand...
 
You must log in or register to reply here.

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

add hyperlink using sheet names and cells(i,j) 3
Copy Data from Within same Workbook 1
Check for two sheets. Add or subtract as necessary. 2
Excel Moving data to sheet2 from sheet1 0
How Do I Avoid #REF! In Formulas? 4
Sum Cells Based on Color 5
Excel VBA to move cells to sheet2 based on selection in sheet1 0
if statement, change cell only if true 4

Back
Top