Adding amounts from several worksheets.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an easy way to add cell C3 from 12 different worksheets and input the answer into the 13th sheet cell C3?
 
Hi
try the following
in cell C13 of your 13th sheet enter the following:
=SUM(
- now select with your mouse the first sheet (sheet1) and select cell
C13 on this sheet
- hold down the shift key and select with your mose the 12th sheet
- finish the formula (add the closing bracket) and hit ENTER

or you ca manuall enter a formula like:
=SUM('sheet1:sheet12'!C13)
 
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

Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Date Format returned from Userform to Excel worksheet 7
difficulty with percentage from worksheet as seen by VBA 1
worksheet change? 10
Copy Data from Sheet 1 to Empty Cell in Sheet 2 2
Get date from prior sheet and add 7 days 6
Reference is not valid 9
Rename a worksheet that includes a cell refeerence 2

Back
Top