software

I am trying to post invoices and I need to total my columns but I do not know
how to do it. The columns I need to total are E3 TO E155, F3 TO F155, G3 TO
G155,H3 TO H155. Then I need to add the totals form column F with column H .
Please Help me!


hi

select E3:I156
simply click the quot;autosumquot; button in the tool bar!
you will get all your row totals,column totals as well as the grand
total

-via135

lilly Wrote:
gt; I am trying to post invoices and I need to total my columns but I do not
gt; know
gt; how to do it. The columns I need to total are E3 TO E155, F3 TO F155,
gt; G3 TO
gt; G155,H3 TO H155. Then I need to add the totals form column F with
gt; column H .
gt; Please Help me!--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=510175In E156 add

=SUM(E3:E155)

copy E156 across to G156, then in H 156 add

=SUM(E155:G155)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;lillyquot; gt; wrote in message
...
gt; I am trying to post invoices and I need to total my columns but I do not
know
gt; how to do it. The columns I need to total are E3 TO E155, F3 TO F155, G3
TO
gt; G155,H3 TO H155. Then I need to add the totals form column F with column H
..
gt; Please Help me!
To total a range of cells in column use =SUM(E3:E155)
In a row =SUM(F200:K200)

I do not want to be rude but this is very basic. Perhaps you need to read a
simple Excel book before you embark on this project.
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;lillyquot; gt; wrote in message
...
gt;I am trying to post invoices and I need to total my columns but I do not
gt;know
gt; how to do it. The columns I need to total are E3 TO E155, F3 TO F155, G3
gt; TO
gt; G155,H3 TO H155. Then I need to add the totals form column F with column H
gt; .
gt; Please Help me!

quot;lillyquot; gt; wrote in message
...
gt;I am trying to post invoices and I need to total my columns but I do not
gt;know
gt; how to do it. The columns I need to total are E3 TO E155, F3 TO F155, G3
gt; TO
gt; G155,H3 TO H155. Then I need to add the totals form column F with column H
gt; .
gt; Please Help me!

In E2 type =sum(e3:e155)
In F2 type =sum(f3:e155)
In G2 type =sum(g3:155)
In H2 type =sum(h3:h155)In F1 type =sum(f2 h2)

Sorry for the simplicity Lilly. Cells E2, F2, G2, H2 amp; F1 are arbitrary,
you can type the formulas into any
cell where you want the answers to go.

Mickey