#1
|
|||
|
|||
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) |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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? |
#4
|
||||
|
||||
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 |
#5
|
|||
|
|||
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. |
#6
|
||||
|
||||
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.
|
#7
|
||||
|
||||
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 |
#8
|
||||
|
||||
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.
|
#9
|
||||
|
||||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How remove colon ':' from my chapter references? | peytontodd | Word | 7 | 10-25-2023 07:13 PM |
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 |