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.
Share a personalized message with your friends.