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

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

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

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

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

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