Worksheet - Functions from sheet to sheet

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

Guest

can a function be placed in worksheet 2 that adds up numbers/data from
worksheet 1?
 
Yes, for instance

=SUM(Sheet1!A1:A18)

will sum A1:A18 in Sheet1, the easiest way is to type =SUM(
then just use the mouse to select the other sheet tab, then select the range
also with the mouse and finish by pressing enter, then Excel will enclose the
formula with a right parenthesis


Regards,

Peo Sjoblom
 
Sure

Simply co to your sheet enter = and then enter the function (I've used SUM)
and click on the other sheet and highlight the cells you want to sum.

=SUM(Sheet1!B7:F7)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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

worksheet renames - specific 0
Summing up various Worksheets to one Summary sheet using variables 1
How to insert new worksheet based on # of rows in a data sourch 2
Excel Move or Copy Stopped Working? 0
Cannot copy worksheet to another file 2
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Need to merge worksheets - Excel 2003 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top