For those who have not yet understood all the positive aspects of the wonderful Excel program, I advise you to familiarize yourself with the various features of spreadsheets in more detail. Many people unreasonably think that this program provides the only opportunity - to "draw" beautiful tablets. This is far from the case, and here are some features and automatic solutions that you can make using Excel.
Automatic summation of data in cells
Let's make a simple table with several rows and columns. For example, these will be the days of the week and the store’s revenue for each day. Fill in any data. Objective: calculate the total revenue for the week.
There are several options for how to add numbers in a column in Excel:
- AutoSum function.
- Application of a simple formula of mathematical addition.
- SUM function.
In addition to these features, the program provides the ability to preview the results without entering them in any cell.
So, let’s take a closer look at all the options, how to add a column with data in Excel.
Applying Results Preview
The simplest action option in this spreadsheet processor is to simply view the results. For this, there is no need to delve into the complexity of the process of writing formulas or finding the necessary functions in the variety of possible.
We have a table with data and it’s enough to select the necessary range and the smart program itself will tell us some results.
We see the average value, we see the number of elements that are involved in the miscalculation and the sum of all the values in the selected range (column). Which is what we needed.– .
«»
. "" . .
. , , . , Excel, «» «» . .
.
, , , "" – « ».
( ), , . , , , .
Excel
, , , .
- «=» .
:
= 6+2
, , . 8.
:
- "" .
:
- .
- =.
- Next, we left-click on the first cell in the column and in our cell for the result we will see how the cell address is automatically added (in this example, cell L2).
- We write the mathematical sign of addition + and click on the second cell.
- By analogy, we add all the necessary cells in the column.
- Press Enter.
This "Excel" formula allows us to add columns without problems, but the method is quite long and not convenient. If you do such manipulations with each column individually, then work on the document will drag on indefinitely. Especially if these are large tables with accounting calculations. To save time and effort, you can use the autofill marker feature described above.A positive aspect of this method relative to the above is the moment of the presence of manually selecting the required cell for the result.
, "" . . :
= (; 1; 2;...xN;)
255 : , , .
"" :
A function window opens, in which there are usually two fields for the cell range “ Number 1” and “Number 2”. For simple operations, a single field is sufficient. We put the cursor in the field “Number 1” and with the usual selection with the mouse we select the range of numbers in the table. Data cells are automatically added, just click the OK button in the lower right part of the function panel.Everything. The required range is added to the result cell, and the selected function automatically processed it.
Similarly, we can add the summation function for the remaining ranges of numbers in our table. However, if you use the knowledge gained and combine various options for working with data tables, you can save a lot of time.
To do this, just use the familiar autofill marker.
These are the most used and simple Excel functions that allow us to no longer wonder how to add a column or row or just two different numbers in Excel.