Go Back   nV News Forums > Software Forums > General Software

Newegg Daily Deals

Reply
 
Thread Tools
Old 02-17-10, 03:21 PM   #1
Van_Dammesque
CoD is GoD
 
Van_Dammesque's Avatar
 
Join Date: Aug 2004
Posts: 49
Default 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.
Van_Dammesque is offline   Reply With Quote
Old 02-17-10, 04:03 PM   #2
ViN86
 
Join Date: Mar 2004
Posts: 15,486
Default Re: EXCEL Help: Seemingly difficult problem!

Quote:
Originally Posted by Van_Dammesque View Post
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.
ViN86 is offline   Reply With Quote
Old 02-17-10, 04:38 PM   #3
Sazar
Sayonara !!!
 
Sazar's Avatar
 
Join Date: Jan 2003
Location: Austin, Texas
Posts: 9,297
Default Re: EXCEL Help: Seemingly difficult problem!

Quote:
Originally Posted by Van_Dammesque View Post
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.
Sazar is offline   Reply With Quote
Old 02-17-10, 05:03 PM   #4
JasonPC
Registered User
 
Join Date: Feb 2007
Posts: 2,103
Default 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.
JasonPC is offline   Reply With Quote
Old 02-23-10, 06:07 PM   #5
Van_Dammesque
CoD is GoD
 
Van_Dammesque's Avatar
 
Join Date: Aug 2004
Posts: 49
Default 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.
Van_Dammesque is offline   Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 11:45 PM.


Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 1998 - 2014, nV News.