| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sum a range of numbers entered into a cell
Can Excel sum a range of numbers entered into a single cell e.g. 25+15+1 = 41
without having to press the Autosum function? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sum a range of numbers entered into a cell
Just prefix the entry with an = character. E.g,
=25+15+1 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "paphos2006" wrote in message ... Can Excel sum a range of numbers entered into a single cell e.g. 25+15+1 = 41 without having to press the Autosum function? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sum a range of numbers entered into a cell
Yes...But you have to let Excel know that you want it to calculate something
by starting with one of these numeric operators: = + - Example: If you enter the below in Cell A1 then press the [Enter] key: +25+15+1 A1 will display 41 Does that help? *********** Regards, Ron XL2002, WinXP-Pro "paphos2006" wrote: Can Excel sum a range of numbers entered into a single cell e.g. 25+15+1 = 41 without having to press the Autosum function? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sum a range of numbers entered into a cell
Thankyou, thats solved my problem, many thanks again
"Ron Coderre" wrote: Yes...But you have to let Excel know that you want it to calculate something by starting with one of these numeric operators: = + - Example: If you enter the below in Cell A1 then press the [Enter] key: +25+15+1 A1 will display 41 Does that help? *********** Regards, Ron XL2002, WinXP-Pro "paphos2006" wrote: Can Excel sum a range of numbers entered into a single cell e.g. 25+15+1 = 41 without having to press the Autosum function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| cell address rather than range name | Excel Discussion (Misc queries) | |||
| macro help | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
