EXCEL Help: Seemingly difficult problem!

Van_Dammesque · 17 Feb 2010 at 20:17

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

I have a table as follows:

PHP:

 A   B   C   D   E   F   G
 6   89  54  21  36  55  98

I SUM A to C cells:

PHP:

=SUM(A1:C1)

As normal. My problem is now repeating the pattern:

PHP:

=SUM(A1:C1), =SUM(D1:F1),...

I would like to click and drag the pattern as above.
However, excel produces this:

PHP:

=SUM(A1:C1), =SUM(B1:D1),...

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

fini · 17 Feb 2010 at 20:21

What are you using this for? To me it's sounding like you might be making subtotals. Have a play with the subtotals tool and see if that does what you want.

PhillyDee · 17 Feb 2010 at 20:30

The only way I know of is to copy the forumla line itself, then paste it into a cell. Instead of copying the cell.

spydermixx · 17 Feb 2010 at 22:42

Assuming '=sum(a1:c1)' goes into cell A2, can you not leave B2 and C2 as blank cells, then while highlighting A2:C2, drag this across? Or do you need the results to be in consecutive cells?

Van_Dammesque · 23 Feb 2010 at 23:11

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.