how do i add up 3 columns to get a total

[Guest]

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

 

[Guest]

In cell J3 enter the following:

=G3+H3+I3

then copy cell J3 from J4 thru J11

 

[Niek Otten]

Or, if you want the total of all the cells:

=SUM(G3:I11)

 

[Norman Jones]

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.

 

[Norman Jones]

Hi Niek, Hi Gary's Student,

Please forgive my intervention.

When I posted, neither of your (substantially) earlier responses was visible
to me.

 

[Niek Otten]

No problem at all, Norman,

This happens to all of us all the time