For demonstration first create work sheet as below. I have created five work sheets with different values for better understanding.
Other work sheet as below
Now, I’m going to calculate total expenses of sheet “US”, ”India”, ”Japan” on “Total” sheet. Steps are given below
Step 1: Select Cell of “Total” sheet where you display sum of values and write “=” sign as below image.
Step 2: Now open “US” sheet and select or write cell index which you want sum with another sheet’s cell value. See below image
Step 3: Now enter “+” sing then select “India” and “Japan” sheet and enter cell index as below image
Now press enter key and see output on “Total” sheet as below image.