G Guest Mar 2, 2006 #1 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?
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?
C Chip Pearson Mar 2, 2006 #2 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 message news:[email protected]...
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 message news:[email protected]...
G Guest Mar 2, 2006 #3 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
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 Mar 2, 2006 #4 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...
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...
