| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell calculation
how do i use one cell as a calculator, or to keep a running total within one
cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell calculation
Put this formula in B1:
=SUM(A1:A10) Then, as you enter values into the range A1 to A10 the running total will be shown in B1. Is this what you meant? Hope this helps. Pete On Nov 25, 2:19*pm, red wrote: how do i use one cell as a calculator, or to keep a running total within one cell? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell calculation
Thanks, Pete, but what I need is to enter # into A1, then enter another #
into A1, & the result to be the sum of the 2 entered #'s, like a calculator, but within the same cell. any hints? "Pete_UK" wrote: Put this formula in B1: =SUM(A1:A10) Then, as you enter values into the range A1 to A10 the running total will be shown in B1. Is this what you meant? Hope this helps. Pete On Nov 25, 2:19 pm, red wrote: how do i use one cell as a calculator, or to keep a running total within one cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a cell value in its own calculation | Excel Worksheet Functions | |||
| YTD calculation using same cell | Excel Worksheet Functions | |||
| Cell Calculation | Excel Worksheet Functions | |||
| How do I exclude a cell from an average calculation when the cell. | Excel Discussion (Misc queries) | |||
| Calculation within a Cell | New Users to Excel | |||
Linear Mode
