Making Sums in Excel
In Excel, you will be doing a lot of the four basic operations: Adding, Substracting, Multiplying, Dividing.
Here the Sum (you saw it already in the previous example but I provide you with some more details)
See how the separation are made.
To make an array, type Reference1:Reference2
To sum various values, separate them with comma.
You can go for quite complex formulas already, look in the line 9. There is the sum of A1+10*A2+100*A3...
Download this example.
Tip1: Learning by doing is the best. So go for it!
Tip2: to edit your formula, move onto it (with keyboard arrow or mouse) and then press F2. This will allow you to edit your formula very easily.
Updated September 12th, 2010
You are visitor no: