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.

Originally Posted by ktchegi

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

the picture is pretty ordinary, by the time I magnify it large enough to be able to read it the image is so blurred it's not understandable.

Do you have problems posting a .zip of a .xls?

the formula is (on row 2)

=A2+D2+G2+K2

drag that 3 right
drag the whole 4 cells downwards as far as.

---

Originally Posted by ktchegi

please note that this file is not a worksheet, i just drew it up to show my requirements, so there are no formulae etc. the actual sheet streches on into the "AX" column and beyond, and it grows as i need to add information.

in B15 you ask the sum of C3:C14

can I presume that you mean =Sum(B3:B14)

formula fill that rightwards.

the formla for K3 is as per the last post

=B3+E3+H3

fill right 2 cells, then fill down to row 15

---

added

of course, you could be 'clever' and use

=SUMPRODUCT(--(B$2:J$2=B$2),(B3:J3))

which will drag right and down, but each time you insert 3 more columns you will still need to amend the formula to include the new columns.

Easiest is to just +C another column for each set of 3 added and Fill the formula as required.

---

Originally Posted by ktchegi

Thank you so much for helping an old man out. Have a good day

good to see, also note, to insert 3 columns before (say) column J, select 3 columns K L & M and then Rightmouse, Insert

amend the formula to

=B3+E3+H3+K3

=B3+E3+H3+K3+N3

etc, or

=SUMPRODUCT(--(B$2:M$2=B$2),(B3:M3))

=SUMPRODUCT(--(B$2:P$2=B$2),(B3:P3))

then fill right 2 cells, then fill down to row 15


Thanks for your response.
---