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

L

lilly

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!
 
V

via135

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
 
B

Bob Phillips

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

Bernard Liengme

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
 
M

Mickey Mouse

lilly said:
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!
Click to expand...

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
 
Top