| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I add rows on excell using the =sum function
i have 100
200 300 about 7 numbers and I would like to know how to add them. =sum (g1-15)? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I add rows on excell using the =sum function
If your numbers are in the range G1 to G15 try it like this:
=SUM(G1:G15) When you need to reference a range of cells think of the colon as the word "to". G1 to G15 = G1:G15. -- Biff Microsoft Excel MVP "mona" wrote in message ... i have 100 200 300 about 7 numbers and I would like to know how to add them. =sum (g1-15)? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I add rows on excell using the =sum function
Hi,
=sum(G1:G15) if this helps please click yes thanks "mona" wrote: i have 100 200 300 about 7 numbers and I would like to know how to add them. =sum (g1-15)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot add rows in Excell 2002 | Excel Discussion (Misc queries) | |||
| Inserting blank rows in Excell | Excel Discussion (Misc queries) | |||
| excell does not print rows or columns | Excel Discussion (Misc queries) | |||
| Excell, why oh why can't you just move rows up and down !!!!! | Excel Discussion (Misc queries) | |||
| How do I sort by complete rows in excell | Excel Worksheet Functions | |||
Linear Mode
