Build Your Resume To Get Connected for Jobs and Internships - Resume Builder
Build Your Resume To Get Connected for Jobs and Internships - Resume Builder
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.
Learn Making Professional-Quality Documents With MS Wor...
Enroll For Free
Impress Everyone With Fluent Communication Skills With...
Enroll For Free
Enhance your customer engagement skills with our Custom...
Enroll For Free
Improve Your Presentation and Team Management With Soft...
Enroll For Free
Become A Master In Sales With Career In Sales Taught In...
Enroll For Free
Have a friend to whom you would want to share this course?
