sum a range of numbers entered into a cell

P

paphos2006

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?
 
R

Ron Coderre

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
 
P

paphos2006

Thankyou, thats solved my problem, many thanks again

Ron Coderre said:
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 said:
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?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Excel does not accept text format! 0
The sum of the same function that is used for a range of cells 2
Controlling Cells included in a sum command 3
Sum of two highest numbers 7
Cell doesn't appear in calculations 4
Finding the proper style field and the numbered paragraph value within the style 0
WORD VBA Search and switch to advanced ... 1

Top