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;
- Oct 05 Fri 2007 20:40
how do i add up 3 columns to get a total
close
全站熱搜
留言列表
發表留言