below the formulas bar the dialoge box Function
appear. It will ask you for the function arguments. The box will vary according to
the function chosen. In this case we have chosen the function SUM
box you must indicate the
that will generally be a cell or a range of cells like A1:B4
To do that, you should click on the button
the box gets smaller and you can see all the spreadsheet. After that, select
the range of cells or the cell you wish as your first argument (to
select a range of cells click with the left button of the mouse on the first cell
of the range and without letting go drag to the last cell of the range) and press
the key ENTER
return to the dialoge box.
the box Number
must indicate your second
of course, only when there is one.
you introduce a second argument, another box will appear for the third argument,
and so on.
you have introduced all the arguments, click on the button OK.
for whatever reason we
a row in the middle of a function range, Excel
will expand automatically the range Including
the cell value in the range. For example: If you have in cell
you insert a row in position 3, the formula will expand automatically changing to =SUM(A1:A5) .