Course Content

Course Content


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.


Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download The Apps

Code Scan or Download the app
Google Play Store
297K+ Downloads
4.5 Rating
10K+ Reviews
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere