sum a range of numbers entered into a cell

G

Guest

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

Guest

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
 
G

Guest

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

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel How to add numbers in same cell? 2
Cell doesn't appear in calculations 4
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
computing sums 2
When I type 10 in a cell I keep getting 0.1 instead. Any thoughts 2
Excel - Sum Error 2
Excel JUMP FROM SEARCH BAR TO RESULT 3

Top