| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 ... 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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 ... 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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formula - language needed | Excel Worksheet Functions | |||
| @SUM Total Changes | Excel Worksheet Functions | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Linear Mode
