summing cells in different worksheet

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
 
A

Arvi Laanemets

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
 
G

Guest

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...
 

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

Need Help with a VBA subroutine 0
add hyperlink using sheet names and cells(i,j) 3
How Do I Avoid #REF! In Formulas? 5
Automatically populating cells down a row 8
Copy Data from Within same Workbook 1
HELP: IF Statement between Dates for Reverse Index failing 0
Index Match to ignore blank cells 0
use month in cell date to sum all relevant cells 2

Top