How To Use of Formula in Worksheet
Now we will see that how we can use formula in multiple worksheets together.
Suppose if you want to enter the total salary of any one person in a particular sheet, whose different salaries are written in different sheets, so for that we will simple use our usual formula method.
We will write equal to (=) in the cell where we want the total salary to be written and then proceed by selecting the cells from different sheets where the persons salaries are written.
This will give us the total salary of that particular person from different sheets together to our required cell.
Now if we have many different rows to calculate then and we can just simply use 'Sum' function for getting the total salary.
To get 'Sum' function we can simply press 'Alt+=' key from our keyboard, and after that select every cell from different sheets to get the total salary.
To view that which formula we used, we can just simply use 'Show Formulas' option from FORMULAS tab.
Have a friend to whom you would want to share this course?