Oct 21 2020 02:06 PM
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
Oct 21 2020 02:12 PM
The easiest way to do this is by pointing. Let's take sum as example; it's similar for median etc.
Oct 21 2020 02:13 PM
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
Oct 21 2020 02:19 PM
@Hans Vogelaaryeah that didn't do it it just jacked up the other sheet tab I made already
Oct 21 2020 02:27 PM - edited Oct 21 2020 02:58 PM
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.
Oct 21 2020 02:46 PM
@Hans Vogelaarok that was what I needed thank you so much