| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is excel compatible with ANSOS one staff program ? | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| print excel columns on less pages | Excel Discussion (Misc queries) | |||
| Mexport transfer from another program to excel opens at excel lau. | Excel Discussion (Misc queries) | |||
Hybrid Mode
