EXCEL Help: Seemingly difficult problem!

Van_Dammesque · 02-17-10, 02:21 PM

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

I have a table as follows:

PHP Code:


			
 A   B   C   D   E   F   G

 6   89  54  21  36  55  98

I SUM A to C cells:

PHP Code:


			
=SUM(A1:C1)

As normal. My problem is now repeating the pattern:

PHP Code:


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

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

PHP Code:


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

How do I get excel to do what I want?

ViN86 · 02-17-10, 03:03 PM

Quote:

Originally Posted by Van_Dammesque

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

I have a table as follows:

PHP Code:


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

I SUM A to C cells:

PHP Code:


			
=SUM(A1:C1)

As normal. My problem is now repeating the pattern:

PHP Code:


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

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

PHP Code:


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

How do I get excel to do what I want?

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 · 02-17-10, 03:38 PM

Quote:

Originally Posted by Van_Dammesque

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

I have a table as follows:

PHP Code:


			
 A   B   C   D   E   F   G

 6   89  54  21  36  55  98

I SUM A to C cells:

PHP Code:


			
=SUM(A1:C1)

As normal. My problem is now repeating the pattern:

PHP Code:


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

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

PHP Code:


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

How do I get excel to do what I want?

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 · 02-17-10, 04:03 PM

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 · 02-23-10, 05:07 PM

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.

02-17-10, 02:21 PM	#1
Van_Dammesque CoD is GoD Join Date: Aug 2004 Posts: 49	EXCEL Help: Seemingly difficult problem! Hi Guys, A need help on a SUM and cell reference problem. I have a table as follows: PHP Code: `A B C D E F G 6 89 54 21 36 55 98` I SUM A to C cells: PHP Code: `=SUM(A1:C1)` As normal. My problem is now repeating the pattern: PHP Code: `=SUM(A1:C1), =SUM(D1:F1),...` I would like to click and drag the pattern as above. However, excel produces this: PHP Code: `=SUM(A1:C1), =SUM(B1:D1),...` How do I get excel to do what I want? __________________ Linux is free, if your time is worthless.

02-17-10, 04:03 PM	#4
JasonPC Registered User Join Date: Feb 2007 Posts: 2,103	Re: EXCEL Help: Seemingly difficult problem! Excel typically won't pick up complicated patterns. It's more about the location of the cells. You may have to manually do this.

02-23-10, 05:07 PM	#5
Van_Dammesque CoD is GoD Join Date: Aug 2004 Posts: 49	Re: EXCEL Help: Seemingly difficult problem! 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. __________________ Linux is free, if your time is worthless.