automatically update results in series of columns

Originally Posted by ktchegi

I have a worksheet consisting of many sets of data in groups of three columns ie
A,B,C then D,E F and so on. At the end of worksheet i have totals ie A+D+G etc then B+E+H..... Is there a way of automatically adding these individual totals to give the final result. All I do at present is select each one then "+" which is time consuming.

Hi,

if you write the formula once, you should then be able to formula fill sideways and downwards.

Formula fill is shown at http://www.mvps.org/dmcritchie/excel/fillhand.htm

hth
---

I tried the info, but I am not able to get it to work. The attached screenshot will hopefully assist. TIA

Originally Posted by ktchegi

I tried the info, but I am not able to get it to work. The attached screenshot will hopefully assist. TIA

the attachement was a Word document, this is an Excel forum.

Question, do you understand, and can you do, Formula Fill (aka Formula drag)

---

I can drag formulae, my problems is not knowing how to structure the formula. Hope this image is ok.