ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Any body help me out with this? (https://www.excelbanter.com/excel-discussion-misc-queries/94194-any-body-help-me-out.html)

wwwrabbit

Any body help me out with this?
 

http://www.usd.edu/trio/tut/excel/14.html

I can't get sum of the selection.


+-------------------------------------------------------------------+
|Filename: book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4893 |
+-------------------------------------------------------------------+

--
wwwrabbit
------------------------------------------------------------------------
wwwrabbit's Profile: http://www.excelforum.com/member.php...o&userid=35397
View this thread: http://www.excelforum.com/showthread...hreadid=552373


Toppers

Any body help me out with this?
 
To sum the cells, highlight the range you require so you get

=SUM(A1:B3)

In your example in cell D1 type

=SUM( . then highlight cells A1:B3 ... and A1:B3 will appear in formula
.... add closing bracket ) and hit enter.

OR

type =SUM(A1:B3) and hit enter

HTH

"wwwrabbit" wrote:


http://www.usd.edu/trio/tut/excel/14.html

I can't get sum of the selection.


+-------------------------------------------------------------------+
|Filename: book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4893 |
+-------------------------------------------------------------------+

--
wwwrabbit
------------------------------------------------------------------------
wwwrabbit's Profile: http://www.excelforum.com/member.php...o&userid=35397
View this thread: http://www.excelforum.com/showthread...hreadid=552373



Bernard Liengme

Any body help me out with this?
 
Either type =SUM(A1:B3) and hit enter

or type =SUM(
use the mouse to highlight A1:B3
type )
hit enter

problem solved?

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"wwwrabbit" wrote
in message ...

http://www.usd.edu/trio/tut/excel/14.html

I can't get sum of the selection.


+-------------------------------------------------------------------+
|Filename: book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4893 |
+-------------------------------------------------------------------+

--
wwwrabbit
------------------------------------------------------------------------
wwwrabbit's Profile:
http://www.excelforum.com/member.php...o&userid=35397
View this thread: http://www.excelforum.com/showthread...hreadid=552373




wwwrabbit

Any body help me out with this?
 

Thank you.


--
wwwrabbit
------------------------------------------------------------------------
wwwrabbit's Profile: http://www.excelforum.com/member.php...o&userid=35397
View this thread: http://www.excelforum.com/showthread...hreadid=552373



All times are GMT +1. The time now is 11:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com