excel for computer class issue

[sam1925]

I have an excel question I am trying to take a sum from one sheet and input the formula on another aka sum,average,median highest lowest I have three worksheets 2 I have been using and a summary sheet I created I do not understand how to take the data from the other two sheets for my formula and input them on my blank summary sheet. id email my professor but hes a douche and wont explain it help.. please

[#2]

@sam1925 

The easiest way to do this is by pointing. Let's take sum as example; it's similar for median etc.

1. Select the cell where you want the formula.
2. Type   =SUM(
3. Click on the sheet tab of the sheet with the cells that you want to sum.
4. Select the range that you want to sum.
5. Press   )   and then press Tab or Enter.

[#3]

i@Hans Vogelaar I will gladly try that however the lasttime I did the first time it included the summary the second time it spilled

[#4]

@Hans Vogelaaryeah that didn't do it it just jacked up the other sheet tab I made already 

[#5]

@sam1925 

Then you must have done something wrong.

You can also type the entire formula.

Let's say you want to sum the cells D2:D50 on a worksheet named My Sheet.

The formula is

=SUM('My Sheet'!D2:D50)

Strictly speaking, the single quotes around the sheet name are only required if that name contains spaces or punctuation, but it doesn't hurt to use them if not.

[#6]

@Hans Vogelaarok that was what I needed thank you so much