expose the 3 following procedures so you can achieve SUMA
1 .- SECURITIES AMOUNT FIXED IN A CELL
This method add the numbers with simple formula. The process is as follows:
a) Write in cell where you want the result, the sign =
b) Add the number or value that you want to add, which must be strictly numerical.
c) After adding the value, add the sign + .
order to add more than one value repeat step B and C. You can add as many numbers as you like, as the example in the formula bar.
d) Once the values \u200b\u200bentered the function with a closing parenthesis ) and now you can press ENTER or OK.
This method is too crude. Is recommended only for small amounts and when the values \u200b\u200bin the cell are fixed.
In the example, show the operation in cell C3 and repeat the operation in cell C6 , but this time only showing the result.
The formula is as follows: = 2 +3 +5
** Remember that the sign = always should be the start of any formula. **
Excel only adds numeric values: integers, decimal, date, time, etc. but NEVER type characters TEXT.
2 .- AMOUNT IN CELLS WITH DIFFERENT VALUES FIXED OR VARIABLE
There are situations where the cells you want to add are values \u200b\u200bthat are in different positions, distant from each other, and either by columns or rows (see image-example).
There are also occasions where the values \u200b\u200binserted into a cell are constantly being updated or modified. This example is unusual in payment formats, payroll or any format to serve literally as calculator (see image-example).
The process, without further ado is:
a) Write the cell where you want the result, signs = (
b) Add number or value that you want to add by selecting with your mouse or cursor cell where the first value.
c) After adding the value add + sign.
order to add more than one value repeat step B and C. You can add as many cells as you want, as the example in the formula bar. Once selected
cells function with a closing parenthesis ) and now you can press ENTER or OK.
Our example was as follows: Adding the cells
: C4, C5 , H3, G9 and E13 .
The formula is as follows: = C4 + C5 + H3 + G9 + E13
** Remember that the wording of the formulas should never have spaces between one character to another.
3 .- ADD-FUNCTION SUM (FOR CONTINUOUS RANGE)
This method is highly recommended when you have a medium or long CONTINUOUS list or range of numbers to add, but also can be used in small amounts. For this method the values \u200b\u200bof the cells may or may not be fixed, it does not interfere with the result. The structure of the function is: ADD = (RANK) .
The structure of the formula was as follows:
a) Write the cell where you want the result, = ADD (
b) Select the range of cells to be added. You can select the range with the arrow keys or the mouse.
c) Once the range of cells close the function with parentheses ) and now you can press ENTER or OK.
Another option for adding long ranges is to select the cells you want to add and then click on the Standard toolbar auto sum button (shown circled in red).
COMBINING METHODS TO ADD
course you can combine the 3 forms of ADD as has the mastery of these and especially depending on your creativity and necessity.
below shows an example of a combination of methods returning to the previous year with values \u200b\u200bin scattered cells in an Excel spreadsheet.
The values \u200b\u200bare added to the cells: C4, C5 , H3, G9 and E13 .
This time combine function ADD NO CONTINUOUS ranging, ie cells at different positions.
To do this procedure all you need is:
a) Write the cell where you want the result, = ADD (
b) Select the cells you want to add: We will achieve this by pressing the CTRL key (Control) straight (without releasing) while we go with the mouse selecting the cells you want to add. Once the selection of cells can release CTRL.
c) The last step is to close the formula with a break ) and now you can press ENTER or OK.
The formula should have been as follows: ADD = (C4, C5, H3, G9, E13)
** If your computer is set to ENGLISH language, it is likely need to use: instead of ; This observation, the stress for those who prefer to manually write the complete formula instead of using the mouse cursor or when choosing to join the ranks. **
The equivalent function ADD in English is SUM .
0 comments:
Post a Comment