Friday, May 25, 2012

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