If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do i add up 3 columns to get a total
i have data in columns g3 to g11,h3to h11,i3 to i11 in column j i need to
total from all the other columns |
#2
|
|||
|
|||
how do i add up 3 columns to get a total
In cell J3 enter the following:
=G3+H3+I3 then copy cell J3 from J4 thru J11 -- Gary's Student "dekmag" wrote: i have data in columns g3 to g11,h3to h11,i3 to i11 in column j i need to total from all the other columns |
#3
|
|||
|
|||
how do i add up 3 columns to get a total
Or, if you want the total of all the cells:
=SUM(G3:I11) -- Kind regards, Niek Otten "Gary''s Student" wrote in message news In cell J3 enter the following: =G3+H3+I3 then copy cell J3 from J4 thru J11 -- Gary's Student "dekmag" wrote: i have data in columns g3 to g11,h3to h11,i3 to i11 in column j i need to total from all the other columns |
#4
|
|||
|
|||
how do i add up 3 columns to get a total
Hi Dekmag,
i have data in columns g3 to g11,h3to h11,i3 to i11 in column j i need to total from all the other columns Look at the SUM fuction in Excel help. --- Regards, Norman |
#5
|
|||
|
|||
how do i add up 3 columns to get a total
Hi Niek, Hi Gary's Student,
Please forgive my intervention. When I posted, neither of your (substantially) earlier responses was visible to me. --- Regards, Norman "Niek Otten" wrote in message ... Or, if you want the total of all the cells: =SUM(G3:I11) -- Kind regards, Niek Otten "Gary''s Student" wrote in message news In cell J3 enter the following: =G3+H3+I3 then copy cell J3 from J4 thru J11 -- Gary's Student "dekmag" wrote: i have data in columns g3 to g11,h3to h11,i3 to i11 in column j i need to total from all the other columns |
#6
|
|||
|
|||
how do i add up 3 columns to get a total
No problem at all, Norman,
This happens to all of us all the time -- Kind regards, Niek Otten "Norman Jones" wrote in message ... Hi Niek, Hi Gary's Student, Please forgive my intervention. When I posted, neither of your (substantially) earlier responses was visible to me. --- Regards, Norman "Niek Otten" wrote in message ... Or, if you want the total of all the cells: =SUM(G3:I11) -- Kind regards, Niek Otten "Gary''s Student" wrote in message news In cell J3 enter the following: =G3+H3+I3 then copy cell J3 from J4 thru J11 -- Gary's Student "dekmag" wrote: i have data in columns g3 to g11,h3to h11,i3 to i11 in column j i need to total from all the other columns |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Max Total of "Max" in reports | buddhapenguin | General Discussion | 1 | June 1st, 2005 12:11 AM |
incorrect sums in report using 2 tables | jkendrick75 | Setting Up & Running Reports | 22 | December 13th, 2004 02:19 PM |
Total across columns | bagia | Setting Up & Running Reports | 2 | June 25th, 2004 09:06 PM |
monthly total from associating cost & date in two columns | Andrew | Worksheet Functions | 1 | May 15th, 2004 10:07 AM |