Creating a Reference to another Sheet or Workbook
Excel sheet provide one most important feature to set reference with another sheet or workbook. You use external references when working with large amounts of data or complex formulas that are spread across several workbooks.
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.