With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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
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.
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