# Thread: formula to add columns together (2003)

1. ## 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?

2. ## Re: formula to add cloumns together (2003)

row total in each appropriate cell in column G please

3. ## Re: formula to add cloumns together (2003)

in G1 enter:
<pre>=SUM(A1:F1)</pre>

then copy G1 down the rows

Steve

4. ## Re: formula to add cloumns together (2003)

is there a formoula so i dont have to copy and paste down G?

5. ## 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 dbl-click and it will autofill down the rows.

If that is not what you are after could you elaborate?

Steve

6. ## 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?

7. ## 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,H1-1,0,1,5))</pre>

If that is not what you are after, you will have to elaborate.

Steve

8. ## 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.

9. ## 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.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•