in this brief video I'm going to cover one of the Excel functions rather using formulas
to post values across worksheets in Excel the process is the same for pretty much any type of
spreadsheet software in my case I'm using Excel 2010 so in our scenario let's say that we have
multiple worksheets and we are going to keep that of expenses for each month in these worksheets now
in one of those worksheets we want for example in here in the very beginning we want to keep
track and have a summary of all the expenses from each one of those worksheets individual ones so
the question is how can we bring for example the totals for example for the training expenses from
January that will have them posted here how can we bring that total back to the training summary
sheet and the same prison will go under computer expenses for January go through February March and
all the other months so the concept is pretty simple so let's say that we have a value here
in the in cell i-5 let's say we have a value of 40 now if we want on j8 to replicate this value
then what we do is the very simple things we press equal and then we put the reference so in our case
I'm going to click here on the reference i-5 and then I hit enter so notice it was the equal sign
clicking on the actual reference and then we hit enter so notice number 40 now is replicating if
I change this to 50 and hit enter you know this that value will be replicated so the idea is how
can we take an expense or a number from another worksheet and post that total in a different
worksheet of the same spreadsheet so is what we need to do so we go under January for example and
we put under taming for example with Excel and so on so now here in the very top we don't put a
total for training and this is assumes that you have done this beforehand so now the total here
we calculated just in case you don't know we put the equal sign then sum open parenthesis and then
we just choose the whole range for training so you can pick also predefined the whole range here
because I might put more stuff in there you know this it's now 150 now let's say we did also pair
up in that let's say those are hundred dollars so now notice it's 250 the total for this by the way
this total you could have done it also using a formula here by choosing the sum function but
personally I prefer to use it make the manual a equal and a function and in the range so now if
we go here under office supplies we do let's say pencils one hundred dollars and so on of course
that's a lot of money for just paper clips now we get the total here for office supplies and if
we wanted to do that know this I can do it's also using the the function here this is the automated
way and notice the reason why I don't like the automated the way is because it puts or it picks
things on its own that may not be correct so we need to do is we need to pick this other range
down here but know there's a concept it's pretty much the same and then let's say we got also
software okay we have training expenses they total to 250 and then office supplies to 270 now if you
go to February as well you could have additional expenses here as well okay we get a total here we
have let's suppose that we have for March April and so on we get the idea the zoom and now we
want to go under the crop she calculations or our summary worksheet here and let's say under January
we want to post the total that is under the January worksheet right here this number we want
to post it on the summary one so what we do is remember the concept from the beginning in order
to replicate 50 here we just do equal then the reference to that cell and then we hit them enter
same thing here we do the equal sign we switch to the worksheet that we want to get a reference
and then we click on the cell that we ever grabbed the value from hit enter and know this it's posted
three steps again your equal where we want to start at the location then we go on the other
worksheet where we want to get the total so click on that cell and then number three hit enter so
it's very simple so if I go to February as well get the training expenses for February we go
under that worksheet actually we put the equal sign first then we go to the worksheet go to
the cell and then select it and hit enter now the nice thing about this is that if I go for normal
to my January expenses for training and for some reason I add more expenses to it so let's say I
had another expense here if if you go to 75 here now notice under my summary worksheet that has
been posted automatically so this is an easy way to utilize formulas to get values from various
cells in different worksheets and have those values posted on a summary sheet to keep track
of expenses to keep track of values and so on so hopefully it's helpful and beneficial for you