yogi_Sum Up Sheet1_B:D In Sheet2 And Even If A Column Is Inserted In Sheet1 Sheet2 Should Still Show Sum Of Sheet1_B:D

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #559    May 25, 2012     www.energyefficientbuild.com.

user murality123 said:
Sum - issues
using google docs, want to do a sum from other spread sheet, but when i insert a column the values are changing.

Example: 

1] Sheet1 has numbers in coulmn B, C, & D

2] Sheet2 have done sum of Sheet1's B C & D

3] If i Insert a Column in Sheet1 B... total in the sheet2 is showing a sum of column C, D & E.

Would like to know how do i get the values of only colum B C & D's values in the other spread sheet... even if i insert columns in Sheet1 - sum value should change only if the value changes in column B,C, & D

-----------------------------------------------------------------------------------------------------

following is a solution to the problem