close

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

In cell J3 enter the following:

=G3 H3 I3

then copy cell J3 from J4 thru J11
--
Gary's Studentquot;dekmagquot; wrote:

gt; i have data in columns g3 to g11,h3to h11,i3 to i11 in column j i need to
gt; total from all the other columns

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

=SUM(G3:I11)

--
Kind regards,

Niek Otten

quot;Gary''s Studentquot; gt; wrote in message
news
gt; In cell J3 enter the following:
gt;
gt; =G3 H3 I3
gt;
gt; then copy cell J3 from J4 thru J11
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;dekmagquot; wrote:
gt;
gt;gt; i have data in columns g3 to g11,h3to h11,i3 to i11 in column j i need
gt;gt; to
gt;gt; total from all the other columns
Hi Dekmag,

gt; i have data in columns g3 to g11,h3to h11,i3 to i11 in column j i need to
gt; total from all the other columns

Look at the SUM fuction in Excel help.

---
Regards,
NormanHi Niek, Hi Gary's Student,

Please forgive my intervention.

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

---
Regards,
Norman
quot;Niek Ottenquot; gt; wrote in message
...
gt; Or, if you want the total of all the cells:
gt;
gt; =SUM(G3:I11)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Gary''s Studentquot; gt; wrote in
gt; message news
gt;gt; In cell J3 enter the following:
gt;gt;
gt;gt; =G3 H3 I3
gt;gt;
gt;gt; then copy cell J3 from J4 thru J11
gt;gt; --
gt;gt; Gary's Student
gt;gt;
gt;gt;
gt;gt; quot;dekmagquot; wrote:
gt;gt;
gt;gt;gt; i have data in columns g3 to g11,h3to h11,i3 to i11 in column j i need
gt;gt;gt; to
gt;gt;gt; total from all the other columns
gt;
gt;
No problem at all, Norman,

This happens to all of us all the time

--
Kind regards,

Niek Otten

quot;Norman Jonesquot; gt; wrote in message
...
gt; Hi Niek, Hi Gary's Student,
gt;
gt; Please forgive my intervention.
gt;
gt; When I posted, neither of your (substantially) earlier responses was
gt; visible to me.
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt;
gt; quot;Niek Ottenquot; gt; wrote in message
gt; ...
gt;gt; Or, if you want the total of all the cells:
gt;gt;
gt;gt; =SUM(G3:I11)
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;Gary''s Studentquot; gt; wrote in
gt;gt; message news
gt;gt;gt; In cell J3 enter the following:
gt;gt;gt;
gt;gt;gt; =G3 H3 I3
gt;gt;gt;
gt;gt;gt; then copy cell J3 from J4 thru J11
gt;gt;gt; --
gt;gt;gt; Gary's Student
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; quot;dekmagquot; wrote:
gt;gt;gt;
gt;gt;gt;gt; i have data in columns g3 to g11,h3to h11,i3 to i11 in column j i need
gt;gt;gt;gt; to
gt;gt;gt;gt; total from all the other columns
gt;gt;
gt;gt;
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()