Results 1 to 9 of 9

20050111, 14:53 #1
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 Posts
Re: formula to add cloumns together (2003)
Welcome to Woody's Lounge!
Do you want a grand total in  say  G1, or do you want a row total in each appropriate cell in column G?
Are there other data below the data you want to add together?

20050111, 15:04 #2
 Join Date
 Jan 2005
 Posts
 4
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: formula to add cloumns together (2003)
row total in each appropriate cell in column G please

20050111, 15:43 #3
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: formula to add cloumns together (2003)
in G1 enter:
<pre>=SUM(A1:F1)</pre>
then copy G1 down the rows
Steve

20050111, 16:20 #4
 Join Date
 Jan 2005
 Posts
 4
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: formula to add cloumns together (2003)
is there a formoula so i dont have to copy and paste down G?

20050111, 16:51 #5
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: formula to add cloumns together (2003)
You can got to the bottom right corner of the cell and when the cursor changes to a "+" you can dblclick and it will autofill down the rows.
If that is not what you are after could you elaborate?
Steve

20050111, 17:16 #6
 Join Date
 Jan 2005
 Posts
 4
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: formula to add cloumns together (2003)
i want to make a spread sheet to check addition on tickets.
i need to be able to enter the prices in each row then check the total with the total on my ticket.
i was wondering if there was a way to be able to just add the coulmns and show the answer regardless of how many rows it is?
or am i not making any sence?

20050111, 17:29 #7
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: formula to add cloumns together (2003)
If you want the "grand total" you can do it with the formula:
<pre>=SUM(A:F)</pre>
But you indicated individual rows.
Without copying the formula down all the rows, you can get an individual row using the offset function, (this assumes the row# you are interested in is put in cell H1:
<pre>=SUM(OFFSET($A$1,H11,0,1,5))</pre>
If that is not what you are after, you will have to elaborate.
Steve

20050112, 02:09 #8
 Join Date
 Jan 2001
 Location
 South Carolina, USA
 Posts
 7,295
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: formula to add cloumns together (2003)
You can put Steve's formula [=SUM(A1:F1)] in cell G1 and copy it down past the rows that have any data in A:F. The formula will show a 0 result until you enter numeric data in any of the columns A:F at which time it will show the sum of the numeric cells. If you don't want the 0 to display before you enter any data in A:F, then you can change the formula to:
<pre>=IF(COUNT(A1:F1)>0,SUM(A1:F1),"")
</pre>
Then copy that down.Legare Coleman

20050112, 07:49 #9
 Join Date
 Jan 2005
 Posts
 4
 Thanks
 0
 Thanked 0 Times in 0 Posts
formula to add columns together (2003)
What is the formula to add column a+b+c+d+e+f and the total to appear in g
The row numbers are changing it depends on the number of tickets i have to total.
please help me.