| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
totaling numbers of a cell
Ok I have a cell P which is all my users hosting bills the paid in dollars.
I need to get the total from P1 to p130 added so I have a total amount that was paid. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
totaling numbers of a cell
In another cell, type this: "=SUM(P1:P130)"
That'll do it. "NascarOnline" wrote: Ok I have a cell P which is all my users hosting bills the paid in dollars. I need to get the total from P1 to p130 added so I have a total amount that was paid. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
totaling numbers of a cell
In P131 enter =SUM(P1:P130)
Gord Dibben MS Excel MVP On Fri, 16 Feb 2007 11:24:15 -0800, NascarOnline wrote: Ok I have a cell P which is all my users hosting bills the paid in dollars. I need to get the total from P1 to p130 added so I have a total amount that was paid. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
totaling numbers of a cell
oh, without the quotation marks, of course.
"Lauren Giles" wrote: In another cell, type this: "=SUM(P1:P130)" That'll do it. "NascarOnline" wrote: Ok I have a cell P which is all my users hosting bills the paid in dollars. I need to get the total from P1 to p130 added so I have a total amount that was paid. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
totaling numbers of a cell
Not working it comes out with the total amount that is in p115 and not a
total from p1 to p115 "Gord Dibben" wrote: In P131 enter =SUM(P1:P130) Gord Dibben MS Excel MVP On Fri, 16 Feb 2007 11:24:15 -0800, NascarOnline wrote: Ok I have a cell P which is all my users hosting bills the paid in dollars. I need to get the total from P1 to p130 added so I have a total amount that was paid. Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
totaling numbers of a cell
in other words, it gives you only the value that is in P115 and nothing from
any other cell. If this is the case, there is a chance that the other cells are really text and not numbers even if they look like numbers. in an empty cell enter 1 select that cell and copy select cells P1:P30 paste special multiply. see if the sum works properly now. "NascarOnline" wrote: Not working it comes out with the total amount that is in p115 and not a total from p1 to p115 "Gord Dibben" wrote: In P131 enter =SUM(P1:P130) Gord Dibben MS Excel MVP On Fri, 16 Feb 2007 11:24:15 -0800, NascarOnline wrote: Ok I have a cell P which is all my users hosting bills the paid in dollars. I need to get the total from P1 to p130 added so I have a total amount that was paid. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Totaling the number of comma delimited numbers in a column | Excel Worksheet Functions | |||
| Sub-Totaling | Excel Discussion (Misc queries) | |||
| Random Values totaling Cell value | Excel Discussion (Misc queries) | |||
| Totaling cells from p.c. worksheets to a cell on a server workshee | Excel Discussion (Misc queries) | |||
| finding data between two numbers (1000-1999)and totaling correspo. | Excel Discussion (Misc queries) | |||
Linear Mode
