Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-22-2016, 02:46 AM
Exhale Exhale is offline The difference between a comma and colon when adding? Windows 10 The difference between a comma and colon when adding? Office 2010 64bit
Novice
The difference between a comma and colon when adding?
 
Join Date: Mar 2016
Posts: 14
Exhale is on a distinguished road
Default The difference between a comma and colon when adding?

Sorry for a very simple one but I'm slowly learning Excel...!



What's the difference between these two formulas when I'm trying to add. They seem to do the same thing?

=SUM(A1,A5) and
=SUM(A1:A5)
Reply With Quote
  #2  
Old 03-22-2016, 04:40 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now The difference between a comma and colon when adding? Windows 7 64bit The difference between a comma and colon when adding? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,633
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Hi
the first sums the individual cells, in this case A1 and A5
the second sums the entire range A1,A2,A3,A4,A5
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 03-22-2016, 05:20 AM
Exhale Exhale is offline The difference between a comma and colon when adding? Windows 10 The difference between a comma and colon when adding? Office 2010 64bit
Novice
The difference between a comma and colon when adding?
 
Join Date: Mar 2016
Posts: 14
Exhale is on a distinguished road
Default

Many thanks for your reply.

That makes sense, so if I use the little auto sum symbol in the top right-hand corner, it defaults to the summation of the range that I have selected by clicking and dragging? Can I use the auto sum facility to select individual cells that aren't next to each other?
Reply With Quote
  #4  
Old 03-22-2016, 06:42 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now The difference between a comma and colon when adding? Windows 7 64bit The difference between a comma and colon when adding? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,633
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

In that case, click on the symbol, then while holding the CTRL key down, select each of the cell by clicking on them. Press Enter when finished

Sometimes, if there are many non-contiguous cells, but there is a pattern, there are other methods. But perhaps take it one step at a time
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 03-22-2016, 01:18 PM
Exhale Exhale is offline The difference between a comma and colon when adding? Windows 10 The difference between a comma and colon when adding? Office 2010 64bit
Novice
The difference between a comma and colon when adding?
 
Join Date: Mar 2016
Posts: 14
Exhale is on a distinguished road
Default Using auto sum, can I put the put the total box anywhere?

Thanks for the reply and yes, I'll try using those first before I move on!

Just one more thing, can I locate the cell with the total in it anywhere? How do I 'land' it where I want it? ...maybe remote from the series I want to sum. I've successfully cut and pasted it but is there another, better way?

I've used the click and highlight method for summing contiguous cells but I always get the final total box at the bottom of the column of numbers.
Reply With Quote
  #6  
Old 03-23-2016, 12:59 AM
Debaser's Avatar
Debaser Debaser is offline The difference between a comma and colon when adding? Windows 7 64bit The difference between a comma and colon when adding? Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 204
Debaser will become famous soon enough
Default

The easiest way is to type =SUM( in the cell where you want the output, then select your cells to sum, then type ) and press enter.
Reply With Quote
  #7  
Old 03-23-2016, 01:02 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now The difference between a comma and colon when adding? Windows 7 64bit The difference between a comma and colon when adding? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,633
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

It seems to me that clicking the autosum button, which automatically enters the entire function, including the parenthesis is much easier then typing the function
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #8  
Old 03-23-2016, 02:12 AM
Debaser's Avatar
Debaser Debaser is offline The difference between a comma and colon when adding? Windows 7 64bit The difference between a comma and colon when adding? Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 204
Debaser will become famous soon enough
Default

For SUM specifically, maybe (though I can probably type it faster than I can navigate to autosum on the Ribbon), but for general usage you might as well get used to typing formulas if you want to get anywhere with Excel.
Reply With Quote
  #9  
Old 03-23-2016, 05:26 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now The difference between a comma and colon when adding? Windows 7 64bit The difference between a comma and colon when adding? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,633
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Of course. Nonetheless, as the OP seems to be on a learning curve, why not take it one step at a time ?

To be complete, typing Alt+= ( at the same time) also inserts the function completely
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
The difference between a comma and colon when adding? How remove colon ':' from my chapter references? peytontodd Word 6 01-28-2014 07:20 AM
aligning colon JRaul Word 4 07-07-2012 06:06 AM
Two Spaces After Colon in Word 2010 alpinegroove Word 2 03-01-2012 08:20 AM
Adding comma to a custom type. mcook Excel 1 08-13-2011 03:08 AM
adding a comma in end of each line in word juanb007 Word 0 07-23-2010 01:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft