EXCEL Help: Seemingly difficult problem!

[Van_Dammesque]

Hi Guys,
A need help on a SUM and cell reference problem.

I have a table as follows:
A B C D E F G
6 89 54 21 36 55 98

I SUM A to C cells:

=SUM(A1:C1)

As normal. My problem is now repeating the pattern:
=SUM(A1:C1), =SUM(D1:F1),...

I would like to click and drag the pattern as above.
However, excel produces this:
=SUM(A1:C1), =SUM(B1:D1),...

How do I get excel to do what I want?:confused::confused:

[ViN86]

Hi Guys,
A need help on a SUM and cell reference problem.

I have a table as follows:
A B C D E F G
6 89 54 21 36 55 98

I SUM A to C cells:

=SUM(A1:C1)

As normal. My problem is now repeating the pattern:
=SUM(A1:C1), =SUM(D1:F1),...

I would like to click and drag the pattern as above.
However, excel produces this:
=SUM(A1:C1), =SUM(B1:D1),...

How do I get excel to do what I want?:confused::confused:
You can't just do that then take only the third values? I mean if the pattern is repeating then you will have A1:C1, B1: D1, C1:E1, D1:F1, etc.

Every third one is the one you want.

[Sazar]

Hi Guys,
A need help on a SUM and cell reference problem.

I have a table as follows:
A B C D E F G
6 89 54 21 36 55 98

I SUM A to C cells:

=SUM(A1:C1)

As normal. My problem is now repeating the pattern:
=SUM(A1:C1), =SUM(D1:F1),...

I would like to click and drag the pattern as above.
However, excel produces this:
=SUM(A1:C1), =SUM(B1:D1),...

How do I get excel to do what I want?:confused::confused:

So, what is preventing you from copying the formula across horizontally and then just dragging the cells with the correct formulas into their respective spots?

It's the quickest way to do it I would think right?

Alternatively, do up the formula, repeat it in the adjacent cell and then do a dupe by dragging the cells and then edit as needed. Again, it reduces repetition for you.

[JasonPC]

Excel typically won't pick up complicated patterns. It's more about the location of the cells. You may have to manually do this.

[Van_Dammesque]

Thanks for all your help, I think I'll write a c# program to produce a row of text, delimited, that I can just cut and paste.