How do I use my excel program to total up columns ex. e3 to e155
 

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!

How do I use my excel program to total up columns ex. e3 to e155
 

hi

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

-via135

lilly Wrote:
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!


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=510175

How do I use my excel program to total up columns ex. e3 to e155
 

In 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)

"lilly" wrote in message
...
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!

How do I use my excel program to total up columns ex. e3 to e155
 

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

"lilly" wrote in message
...
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!

How do I use my excel program to total up columns ex. e3 to e155
 

"lilly" wrote in message
...
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!

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 & F1 are arbitrary,
you can type the formulas into any
cell where you want the answers to go.

Mickey