Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
user gary.jenkins said:
I am new to this stuff, but having fun. I am not sure I understand if thereis a solution to this. Attached is a simplified Spreadsheet. Columns A, B, and C contain data. Cell F2 contains the sum of column A, G2 = sum of column B, and H2 = sum of column C. Is there a way to do this where the formula is defined in F2 only ... and extended to G2 and H2?
I can do that ... and have. The problem is that the spreadsheet I am working on is quite a bit more complex, and I would like to be able to do this without copy/paste. For instance, I can do it like this: F2